Switching columns and rows
Switching columns and rows
(OP)
I have converted the data collected from a 1 hour long test in my DAQ (data aquisition)system. I have collected 29 different data points. The default orientation of Excel is to put the headings across the top and the readings below this. Since I have thousands of readings this makes sense to me.
However, I have summarized the data and would like to show the readings at 0, 15, 30 and 60 minutes. With this default format, I have 29 headings and only 4 rows of readings.
My question is this.......................Is there a quick and easy way to switch the headings and rows? Ideally I would like the headings to be in the left side column and the values to the right. This way I can have 29-30 rows and only 4 columns which provides for more legible printing onto a 8.5"x11" sheet of paper in portrait mode.
I have tried rotating the headings to read vertically. This improves the layout, but does not provide me with ideal results.
Any suggestions?
However, I have summarized the data and would like to show the readings at 0, 15, 30 and 60 minutes. With this default format, I have 29 headings and only 4 rows of readings.
My question is this.......................Is there a quick and easy way to switch the headings and rows? Ideally I would like the headings to be in the left side column and the values to the right. This way I can have 29-30 rows and only 4 columns which provides for more legible printing onto a 8.5"x11" sheet of paper in portrait mode.
I have tried rotating the headings to read vertically. This improves the layout, but does not provide me with ideal results.
Any suggestions?





RE: Switching columns and rows
to simply switch or swap columns (headings) and rows, you will need two sheets. one sheet with original data.
1) copy the original data (select all original data)
2) navigate to the 2nd sheet and utilize the paste special command, selecting values & the transpose options. this will transpose the column and row data.
i recommended the two sheets simply due to quantity of data you have. you may accomplish the same task on the same sheet. the choice is yours.
-pmover
RE: Switching columns and rows
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: Switching columns and rows
Thank you very much.
RE: Switching columns and rows
Pity it's not possible to buy internet beers for people.