How to Make Excel Data Horizontal. When you start fresh in Microsoft Excel, you have two options to enter data – horizontal and vertical. But after entering vertical or columnar data, it can ...

You can easily convert horizontal data to vertical and vertical data to horizontal by using the Transpose feature in Excel.

Learn how to Transpose Row to Column in Excel. Transpose converts horizontal row data sheets into vertical column style sheets and back.