![]() Then select the place where you want to paste, right-click, and from the drop-down menu, choose Paste Special.First, select the data range you want to transpose, right-click it, and choose Copy (or use the CTRL + C shortcut). 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).Fortunately, there is a quick way to change the orientation of data in Excel. Sometimes, it is better to have your row data as a column (transpose the data). ![]() This tutorial demonstrates how to paste horizontal data vertically in Excel and Google Sheets.
0 Comments
Leave a Reply. |