Repeat (Copy/Paste) Transpose Formula

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.