Forum Discussion
How to switch Columns and Rows Excel
I'm trying to use a formula =Data!J$3, but when I spread it downwards it goes =Data!J$3 =Data!J$3 =Data!J$3 I know its correct, but I wanted it to be like this: =Data!J$3 =Data!K$3 =D...
One option is to use the TRANSPOSE function.
Let's say you want to refer to J3:Z3 (17 columns).
Select 17 cells in a column, enter =TRANSPOSE(Data!J3:Z3) and - if you don't have a recent version of Microsoft 365 - press Ctrl+Shift+Enter.
Another option: let's say the first formula will be in a cell in row 2, e.g. D2.
Enter the formula =INDEX(Data!$J$3:$Z$3,COLUMN()-1)
Fill down.
If the first formula is in row 5, use COLUMN()-4 etc.