This scenario came from a recent dilemma a customer had. They got basically the same CSV file every month from a customer but they wanted to have an ongoing summary of it. Of course they could always have done copy and paste – Ye Olde Reliable Standyby…BUT I introduced them to Power Query, more specifically the Folder upload option in Power Query where you store all your identical files, pull them into Excel and then run a pivot from them.
I used dummy data generated from GenerateData.com
You can download a zipped version of the three files here