Transpose a row with formulas

You can use the Offset function to give a cell relative to another cell.
The rows position states how many rows from the start point.
The columns position states how many columns from the start point.
Positive numbers go down and right. Negative numbers go up and left.

So if you state the top of the list you can work down from there.
If the top of your list is in row 1 then this is easy.

=OFFSET($A$1,ROW($A$1)+1,0)

We're using the ROW function to get the row position of your start point and then adding one to it. As you drag the formula it will increment.

If it's not then we need to fudge a bit...

=OFFSET($A$2,C1,0)
Where you've put the offset value in C1.


Here's the link to the help page: https://support.office.com/en-us/article/OFFSET-function-C8DE19AE-DD79-4B9B-A14E-B4D906D11B66

I hope that's not too mind blowing. Let me know if you have any questions.

Claire