Excel

Hi Lisa,

Thank you for your question. To 'swing' your data from rows to columns (and vice versa), first highlight the data. Next, copy the selection, then click on a cell outside the selection. (This is important because you can't paste transpose on top of the original data.)

Right-click on a cell in an empty area, then click the Transpose button in the row of Paste buttons (fourth from left).

This will swing your table's rows and columns.

I hope this helps.

Kind regards
Marius Barnard
Excel Trainer