Back to Tutorial

Lesson 13: Use Transpose to Flip Data on its Side

/en/excel-tips/how-to-make-charts-auto-update/content/

Use Transpose to flip data on its side

Suppose you have a spreadsheet that is arranged into two rows, like the example below:

Screenshot of two rows of data

This arrangement would quickly become unwieldy if more columns were added. It would be better to rearrange this data into two columns instead:

Screenshot of two columns of data

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.

/en/excel-tips/absolute-references-with-the-f4-key/content/