Skip to content

[Excel] How To Use "Transpose" To Rotation The Table

Last Updated on 2021-09-30 by Clay

Today when I using Excel to record experimental data, I had reversed the row and column. The charts that I use to visualize with the data are messed up.

At this point, what I can probably do is to rewrite the program for recording, manual adjust the chart... or transpose the current data. Excel has such a built-in function to transpose!

I will record how to do it in Excel.


Use "Transpose" To Reverse Row And Column

First, assume I have the following table data.

Select all the data, and right-click.

Paste Special > Transpose and you copied the transpose table, you can paste it in any place.

As you can see.


References


Read More

Tags:

Leave a Reply