I Have completed many data projects here and in my line of work, in addition to Six Sigma certification, allows me to do data analysis and analytics solutions in many different ways.
In this GIG i will use Power Query "AKA get and transform" & ETL to do all the data mash, data cleansing and transformations.
Through the powerful MS Power Query allows us to do sophisticated data transformations suing the interface, moreover Its M language is so powerful that we can do almost anything.
Please share which excel version you do have, it is important to know towards finding a solution, i have Excel 365.
Some of the solutions greatly depend on the excel version you have.
Thanks for showing interest in my GIG, i have done several projects using this powerful tool, not only here but in my line of work too.
Looking forward working with you.