How to Convert Horizontal Data into Vertical in Excel
Moving the data manually, one item at a time, would be a tedious process. To save time, you can use the Paste Special command to quickly transpose a column of data to a row of data, or vice versa.