Hi, thank you for showing interest in my GIG, kindly message me before you order so that we can agree on requirements, scope, estimated effort and cost. This gig is all about untangling your data to reap the benefits and to later allow for better analysis and better visualizations. 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 will be very useful to the end results, i have two versions in two different machines excel 2019 and 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.