Please download the file to check my Power Query and Power Pivot solution: there are actually 2 solutions inside: one with PQ to get to the same result as Paula and one Data Model and some Pivots and Slicer in order to Analyze the data, not only to get it in raw form.
File link here: https://1drv.ms/x/s!AoqYOey0DYOTjQRHfsciuKuAcxHZ?e=AqvaPu
You are viewing a single comment's thread from:
hay - well done. I was hoping someone would try this with Power query, nice work