See all How-To Articles

Paste Horizontal Data Vertically in Excel & Google Sheets

This tutorial demonstrates how to paste horizontal data vertically in Excel and Google Sheets.

 

paste horizontal data vertically 5 new

 

Paste Horizontal Data Vertically

Sometimes, it is better to have your row data as a column (transpose the data). Fortunately, there is a quick way to change the orientation of data in Excel.

  1. Say you have some data in a row (e.g., Row 1) that you want to put into a column (here, days of the week). First, select the data range you want to transpose, right-click it, and choose Copy (or use the CTRL + C shortcut).

 

paste horizontal data vertically 1 new

 

  1. Then select the place where you want to paste, right-click, and from the drop-down menu, choose Paste Special.

 

paste horizontal data vertically 2 new

 

  1. The Paste Special window appears. Choose Transpose and click OK.

 

paste horizontal data vertically 4

 

Another way to do this is to select the place where you want to paste the data, right-click it, and under Paste Options click on the Transpose icon, shown in the picture below.

 

paste horizontal data vertically 6

 

As a result, your horizontal data is pasted vertically.

 

paste horizontal data vertically 5 new

 

For guidance on changing the orientation of multiple rows at once, see Rotate Data Tables (Row to Column). To align contents vertically, see How to Write Vertically.

Paste Horizontal Data Vertically in Google Sheets

Pasting horizontal data vertically works similarly in Google Sheets.

  1. Select the data you want to paste vertically, right-click it and then click on Copy (or use the CTRL + C shortcut).

 

paste horizontal data vertically 10 new

 

  1. After that, choose a cell where you want to paste the selected data range and right-click. In the drop-down menu, click on Paste Special, then choose to Paste transposed.

 

paste horizontal data vertically 8 new

 

As a result, the pasted data is vertical.

 

paste horizontal data vertically 9 new