I download data which comes to me in a column. I want to use it in a complex sheet that needs data in a row. How can I convert the column data into row data?

Submitted by: Administrator
Great question. Easy answer: Highlight the data in your column. C to copy it.
Then go to a blank section of your spreadsheet. pick Edit > Paste Special.
In the paste special dialog box, check the little box that says "Transpose". Then click OK. Your column data now turns into row data.
Submitted by: Administrator

Read Online Microsoft Excel Job Interview Questions And Answers