How do you paste a copied columns in rows in excel sheet?

To copy data in rows in a spreadsheet into columns, or data in columns into rows, do a regular copy. Go to the start of where you want to put it and then go to the Edit menu, pick Paste Special and click Transpose and then click OK.