Just got a call today from an accountant wondering how to turn a column of data into a row. If you don’t know, you’ll love it…so simple:
- Highlight the cells you want to flip the orientation on
- Ctrl-C to copy (or copy button…whatever you like)
- Click Edit/Paste Special (might have to expand your Edit menu if you don’t see it)
- Check the Transpose check box in the bottom right and click OK
You can do multiple columns/rows at the same time as well.
The Paste Special menu is tremendously useful, lots to explore there.