Column/Row Transfer Question
Copy your range. Then, after selecting destination first cell,
EditPaste 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
On Jun 22, 8:47 pm, Chris Fearon
wrote:
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!
|