We download data which arrives to me in a column. I need to use it in a complex sheet that requires data in a row. How can we convert the column data into row data?
Ans) 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 whether the little box that says "Transpose". Then click OK. Your column data now changes into row data.