Column/Row Transfer Question

[Chris Fearon]

I want to change the orientation of an Excel spreadsheet. Is there a fast
way to change the horizontal data enteries across multiple columns to now be
stacked vertically in rows (or vice versa)? Thanks in advance!

 

[Toppers]

Look at Copy/Paste Special=>Transpose (at bottom of Paste Special form).

HTH

 

[vezerid]

Copy your range. Then, after selecting destination first cell,
Edit>Paste Special... Check the Transpose checkbox at the bottom.

You can make a permanent link to the original data using the TRANSPOSE
function. Before entering you need to select the entire NxM range (if
MxN was the original). Then, with the entire range selected:

=TRANSPOSE(original range)

Commit with Shift+Ctrl+Enter (array formula)

HTH
Kostis Vezerides

 

[Trevor Shuttleworth]

Copy and PasteSpecial Transpose but the areas can't overlap

Regards

Trevor