Rows to Columns, Columns to Rows

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)

#swap #columns #row