Transposing data
Thank you. That worked.
"Gord Dibben" wrote:
Assuming numbers are in column A
In B1 enter this =INDEX($A$1:$A$3,3-(ROW(A1)-1))
Copy down to B3
Adjust the $A$3,3 to your range of cells.
Gord Dibben MS Excel MVP
On Tue, 21 Aug 2007 12:16:03 -0700, Biff wrote:
I need to transpose a column completely reversed. Can anyone help me with
this? For example:
Befo
1
2
3
After:
3
2
1
Thanks,
Biff
|