Rows to Columns, Columns to Rows
- Enya Low
- Dec 5, 2019
- 1 min read
There are situations where it's easier to sort if values were in columns (vertical) than rows (horizontal), take date for example.
In the video below, I'll show you how to swap a row to a column and vice versa.
CTRL + SHIFT + right arrow (to highlight the entire row)
CTRL + C to copy
CTRL + ALT + V + V + U (paste special values, formats and transpose)
Comments