A quick way is to select the data and use Edit | Copy (or [ctrl]+[C]) and
then pick the place where you want to put it in the new layout and use
Edit | Paste Special
and be sure and click the checkbox next to "Transpose" just above the
buttons, and then click the [OK] button.


"Alan" wrote:

Is there a way to switch data from rows to colums?