Column/Row Transfer Question

C

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!
 
V

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
 
T

Trevor Shuttleworth

Copy and PasteSpecial Transpose but the areas can't overlap

Regards

Trevor
 
Top