Flipping column and row axis

J

jtm

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I'm importing data from a CSV file. Unfortunately, it's oriented in the wrong direction. Is there an easy way to flip the orinetation axis of a worksheet so that the columns become rows and the rows become columns?
 
B

Bob Greenblatt

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I'm importing data from a CSV file. Unfortunately, it's oriented in the wrong
direction. Is there an easy way to flip the orinetation axis of a worksheet so
that the columns become rows and the rows become columns?
Click to expand...
Select the area, copy it. Then select the upper left corner of the
destination and choose Edit-paste special, and click transpose.
 
Top