Change Horizontal Data to Vertical - Excel TRANSPOSE Function

Change Horizontal Data to Vertical. Using the transpose option in paste special option you can make it very easily.

When you're configuring data in a Microsoft Excel worksheet, you may realize that the information you entered in rows makes better sense in columns or vice versa. For example, you're especially likely to run into this problem as you enter more data in a worksheet and discover that with your new information you'll need so many additional columns that your data will scroll off the screen. Rather than retype your data or rearrange it one cell at a time, you can transpose your rows and columns with a special twist on a familiar Excel command.

This tutorial will apply for Microsoft Excel 2021, 2019, 2013, and 2010 for both Windows (such as Dell, HP, Lenovo, Samsung, Toshiba, Acer, Asus) and macOS (MacBook Air, MacBook Pro, MacBook Mini) devices.