Assist me with this Automation by creating a macro

Hi Folks

I need your help in automating my work which i do it in daily basis.

I have attached two spreadsheets, one "Sample_Raw Data" file which has raw data in tab 1 and steps in tab 2
Another "Sample_Final" file is the final output which looks.

https://drive.google.com/folderview?...W8&usp=sharing

Appreciate your help.

Thanks in advance.