Can I reverse the order of data in a set of cells?
One way, insert a new column or use an existing, number it from
1 - n (where n is the last index value you want to reverse the order of,
so if your column is 100 rows number the help column 1, 2, 3 - 100)
select both columns and sort descending on the help column
--
Regards,
Peo Sjoblom
"salwitt" wrote in message
...
I have a column of cells filed with data. I know I can transpose the data
90
degrees, but is there a way to cut or copy the data in the cells and paste
it
so the values are in the opposite order, i.e. a 180 degree difference?
Thanks to anyone who can help.
I am using Excel 2003.
|