Macro to populate Data from Columns into Rows.

Good Day

Please assist me with a Macro that will populate and calculate data that is in Columns into rows.

I have shown an example in the attached spreadsheet on how data is populated and how i want it to display the "Data" tab shows how i receive the data and the "Report" tab shows how i want the macro to pupulate the data

Thanking you in advance

Pitsere