Macro to Reformat/transpose data into table style

Hi All


the attached file contains 2 tabs

1. assumptions

The user will populate the data in the yellow area, please take into account that the number of rows will increase substantially

2. final_results

the macro needs to take the data from tab assumptions and combine it in order to create the data shown in tab "final_results"


thanks in advance

Anthony

thanks Olly, unfortunately the user is not very familiar with power query, can you solve it with Vba as requested?

many thanks