/en/excel-tips/how-to-make-charts-auto-update/content/
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.
Check out the video below to learn how to transpose data.
Though you might not use this feature every day, it can help to rearrange your data into a format that’s easier to read. In Lesson 14, we’ll talk a little bit about absolute references.
/en/excel-tips/absolute-references-with-the-f4-key/content/
About cookies on this site
Sharing your cookies helps us improve the site, optimize your experience, and understand the extent of our impact. By closing this banner, you agree to the use of cookies on this website (This option applies to users outside the United States and Europe). Learn more about how we use cookies by clicking on Cookie Settings.