Transpose multiple columns

G

gabbey.maps

I have a 400 column by 72 row array of data that needs to
be transposed into 72 col x 400 rows. What's the best way
of accomplish this? Best would be to do it one-shot.

-G
 
P

Pete_UK

Highlight all the data, then click <copy>. Move your cursor to a cell
outside the range occupied by the current data (eg to row 74) and
click on Edit | Paste Special | Transpose (check) | OK then <Esc>.

If you are happy that you have ended up with what you wanted, then you
can delete the original 73 rows.

Hope this helps.

Pete
 
G

gabbey.maps

Highlight all the data, then click <copy>. Move your cursor to a cell
outside the range occupied by the current data (eg to row 74) and
click on Edit | Paste Special | Transpose (check) | OK then <Esc>.

If you are happy that you have ended up with what you wanted, then you
can delete the original 73 rows.

Hope this helps.

Pete
Click to expand...

Thanks for that.. I've been transposing single columns into rows but
haven't tried a WHOLE block of data. Will test it out this morning.

-G
 
Top