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

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)

 

 

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

 

 

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

 

 

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.

 

 

As a result, your horizontal data will be pasted vertically.

 

 

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

 

 

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.

 

 

As a result, the pasted data will be vertical.