I need a excel expert

Job ID: 35374286

Budget: ₹600 – ₹1,500 INR

I want to learn about the formulas needed in converting raw into systematic way by drop down technique or if anything better. I have attached the file. The excel data to be converted into the data showed in the pdf. only one time I need to know how it works.
Related categories: Data Processing Data Entry Excel Statistics Mathematics