Pivot Problem (similar, but also different to Paul Boyes' one)

Power Query
3

Hi Melissa.

Thanks for providing that M code.

I have provided an Excel-file now (sorry for not doing it in the first place).

As said, this is only sample data.
The real dataset consists of much more date entries and also there are more than 50 names.

Since your solution is customized to my sample date, my question is if there is a more generic solution, which I can adopt to my real data.

PQ Sample Data SW.xlsx (14.3 KB)

Best regards
Martin

1 Like