Microsoft Excel Question:
Download Questions PDF

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?

Answer:

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.

Download MS Excel Interview Questions And Answers PDF

Previous QuestionNext Question
Thanks for your great answer, but this results in my data be backwards; i.e. rather than 12345 I need it to be 54321. Any further thoughts?How can I enter the symbol for the new Euro currency in my spreadsheet?