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 of the column becomes the number at the far left of the row and the number at the top of the column becomes the number at the far right. How to do that?
Alternatively, if I have a row of numbers how can I switch the order so that the number on the right becomes the number on the left and vice versa?
thank you!
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
