How to Copy Vertically Paste Horizontally in Excel

1. Open the document in Microsoft Excel and highlight the cells you want to copy.
2. Click the 'Home' tab on the Microsoft Office ribbon and click 'Copy.'
3. Click on the cell where you want to paste the data.
4. Click the pull-down menu next to 'Paste' on the 'Home' tab to view a list of paste options, then click 'Transpose.' The copied data is pasted into the highlighted cell and its adjacent cells with the rows and columns reversed.