Transposing rows to column by row, not column (Microsoft Excel)

The Issue

I want to transpose data given in rows to columns.

The Problem

The Excel Paste Special -> Transpose on the full dataset goes by rows instead of by column.

Example

Data

| 1 | 2 | 3 | 4 | 5  |
|---|---|---|---|----|
| 6 | 7 | 8 | 9 | 10 |

Desired Result

| 1  |
| 6  |
| 2  |
| 7  |
| 3  |
| 8  |
| 4  |
| 9  |
| 5  |
| 10 |

I'd like to automate this process, however, I'm not too familiar with VBA. Thanks for any and all help.