Change Horizontal Data to Vertical

If data is arranged horizontally in a worksheet, you can use the TRANSPOSE function to list the data vertically, in a different location. For example, in a summary sheet, or dashboard, a vertical layout might be best. With the TRANSPOSE function, you could link to your original horizontal data, without changing its layout.

To transpose a 2 row x 4 column horizontal range to a 4 row x 2 column vertical range:

1. Select the 8 cells where you want to display the data vertically  -- cells B4:C7 in this example.
2. Type this formula, then enter it as an array formula, by pressing Ctrl+Shift+Enter.

=TRANSPOSE(B1:E2)

Curly brackets will be automatically added at the start and end of the formula, to show that it is array entered.