Rearrange data for PowerBI

Hello,

I have a large Excel spreadsheet with about 1250 rows and about 50 columns, so about 60,000 numbers that I now need to arrange differently for a PowerBI presentation.

Each column represents a product. So there are 50 different products with different characteristic curves.
The characteristic curves are determined by formulas.
The results are arranged one below the other in the same column.
At the top is the speed.
Below that, the power values corresponding to the speeds.
Below that, the torque values corresponding to the speeds.
In the end, the result is a characteristic curve in which the speed is plotted on the X-axis.
The power values are plotted on the Y1 axis.
The torque values are plotted on the Y2 axis.

The special/difficult thing is that the three axes are arranged one below the other in the table.
This was done so that the formulas can be copied to the right to calculate the 50 different products, and so that this can be extended at any time.

PowerBI obviously doesn't get along with this at all, so the data has to be arranged differently.

The whole data should be arranged in 3 columns: Type, Category and Value.
This means that my 1250 rows x 50 columns table will be arranged in 3 columns and 62,500 rows for PowerBI.

This is exactly what I have never done before, my attempts with REFERENCE, SVERWEIS, WVERWEIS, ADDRESS, INDEX, INDIREKT, MTRANS have failed miserably so far.
I just don't find the right approach to implement this.

Please no discussion for the sensefulness or alternative suggestions.
I cannot change the data source or the data usage.
The task is fixed: Rearrange the existing array to produce the needed array of data. No more and no less, any discussion is useless, because I can't change it :-)

Of course I can copy myself silly, but the data should still be controlled by the original table, also extended and changed.
By the use of (any) lookup function or similar one has then only the transformation of the arrangement, which takes over then from the origin table data.

I have attached an example file to show the whole thing in a simplified way.
On the tab "Data" you can see the structure of the raw data.
On the tab "Data for PowerBI" you can see the structure as it should be for PowerBI. Formulas would now have to be entered there to take the data from the "Data" tab (lookup).

Does anyone have a good idea how to implement this?

Thank you very much, and best regards,
Chris