I am sure this must be simple but I cant figure out how you do it.
I want to transpose a range of cells from a row to a column.
I don’t want to switch the data just the cells.
In the example, row 1 has the values in it and in column A, cell A3 downwards has the equation I want to use, for example A3 = A1, A4 = B1 and A5 = C1 etc
If I try to pull down the cells in column A it changes the row number rather than the column number.
How do I do this to make it change the column number when I drag it down?