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.
Watch video How to Convert Horizontal Data into Vertical in Excel online without registration, duration hours minute second in high quality. This video was added by user How to Do it All 03 September 2013, don't forget to share it with your friends and acquaintances, it has been viewed on our site 363,31 once and liked it 1.2 thousand people.