I receive a file in a format that requires me to transpose data. I have attached the file with 2 tabs. One called "Source Data" and another called "Desired Format".
My question is this:
How can I copy and paste this formula
=TRANSPOSE('Source Data'!E2:AI2) (currently in cell I2 of "Desired Format" tab)
so that when I paste it, 33 rows down, in the "Desired Format" tab, it increases the cell reference in the "Source Data" tab by only 1 row:
=TRANSPOSE('Source Data'!E3:AI3) (currently in cell I33 of "Desired Format" tab)
When I try, it comes out like this: =TRANSPOSE('Source Data'!E33:AI33)
I apologize if this is unclear, but it is tricky to try and describe. Open to new ways of looking at this as well. Thank you.
Bookmarks