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.