See all How-To Articles

Paste Horizontal Data Vertically in Excel & Google Sheets

In this tutorial, you will learn 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 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 (in this example, 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

 

2. 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

 

3. The Paste Special window will appear. Choose Transpose and click OK.

 

paste horizontal data vertically 4

 

Note: The other 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 will be 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).

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

 

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

 

paste horizontal data vertically 8 new

 

As a result, the pasted data will be vertical.

 

paste horizontal data vertically 9 new