Suppose you have a spreadsheet that is arranged into two rows, like the example below:
This arrangement would quickly become unwieldy if more columns were added. It would be better to rearrange this data into two columns instead:
Luckily, you don't have to rearrange each cell by hand. Excel can do it automatically using a feature called Transpose, which is available when copying and pasting data.
Watch the video below to learn how to transpose data.