How can I make a column reference a row in another table?

I have this table that was created by using the "Form sheet" on iPad

Table A
-------------------------------------
Month   | Rent | Groceries | Netflix |
January |  100 |       100 |     100 |
February|  200 |       200 |     200 |
-------------------------------------

Naturally, it's weird that the months are the columns, and not the rows. So I want to create a 2nd table that references this table, but transposed

Table B
---------------------------------
Description | January | February |
Rent        |     100 |      200 |
Groceries   |     100 |      200 |

I can make the Cell reference the other table, but when I click+drag to autocomplete the remaining cells (around 20), they follow the column. Table B January Groceries points to Table A February Rent. Of course I could do it manually but it'll take me a few hours, and I'll have to manually update each table if I insert a new column on Table A