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.

With Power Query essentially one command.

Formula:

Please Login or Register  to view this content.

Power Query is a Excel tool and can be added to Excel 2010.
Installing the Power Query Add in in Excel 2010 and 2013

Thanks so much for your reply. Would it look like this in English?

Please Login or Register  to view this content.

I am getting an expression editor in Advanced Editor saying it can't find table Source Data. Thanks again.

The formulas are all in English, only the "name" of the actions are in non-english and it is not relevant for the cod.

Formula:

Please Login or Register  to view this content.

A mistake of your cod could be found in the row bellow since a table name can not be separated by space " ".
Source = Excel.CurrentWorkbook(){[Name="Source Data"]}[Content],

Are you still using 2010, or have you got a newer version as you have spill ranges in your sheet?

I'm sorry about that, I am on 365 now. I have updated my profile with that. My apologies.

Well noticed Fluff13.

I am on 365 now

In that case you can use

Formula:

Please Login or Register  to view this content.

And for the 1st 5 columns you could use

Formula:

Please Login or Register  to view this content.

Another possible 365 formula.

Formula:

Please Login or Register  to view this content.

Thank you both, immensely for the help. Your suggestions worked out fabulously. Thanks again.

Glad to help & thanks for the feedback