Forum Discussion
Copy - Paste - Transpose: how to switch the order of a line or column?
I have a column of data (about 120 random numbers, which are the monthly performance numbers of the S&P500 Index). I want to paste the values and formats into a row so that the number at the bottom o...
There is no direct formula to do this, but a couple of steps should do it - should take no more than 2 minutes:
- duplicate the data
- add a third column numbering the data
- add filter option to all three columns
- Filter the numbering column from largest to smallest
- copy your two columns
- paste choosing "Transpose" (4th icon)
Magic done