Excel data formatting
Have you tried either the TRANSPOSE function or Copy/Paste Special/
Transpose ?
--
David Biddulph
"jreinier" wrote in message
...
I would like to swap the data in an Excel spreadsheet by changing the
columns to rows, and the rows to columns, For example:
This: 1 2 3 Would become this: 1 4 7
4 5 6 2
5 8
7 8 9 3
6 9
Is this possible, and if so how can I do it? I have a large amount of
data and performing this by hand would take an extreme amount of time.
Any assistance you can provide would be appreciated.
--
jreinier
|