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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulas in Chart Titles Axis Titles 4
Switching axis of a chart 4
Chart axis in Excel 0
Double y-axis with double colums 0
Second x axis on x-y charts 0
flipping data 4
how to edit my x-axis data on a line graph 0
Freeze area 2

Top