Hi Mynda, Thanks for an elegant approach, which gets me a long way towards the outcome I want. Just one question: how do I prevent the pivot table...
Hi Mynda, Of course - thanks. I really should have thought of that! I initially merged the Name/meal columns as I couldn't get table.transpose ...
I've achieved my desired result by using: let Source = Excel.CurrentWorkbook(){[Name="tblDiners"]}[Content], #"Changed Type" = Table.TransformColum...
I've made a bit of progress by looking at Catalin's response to "how to transpose a particular column values that tie to userid into Cross table (pivo...
Hi Mynda, Blast! Here it is again. As ever, Pieter
Hi Catalin, Thanks very much - I think that's just what I was looking for. I'll have a play and revert if I get stuck. Thanks again. Pieter
Thanks for your reply, Anders. I get that and I do exactly that where possible. In this case it isn't and my underlying question is simply: how to s...
Hy Mynda, Great advice - many thanks. Pieter
Hi Mynda, That's absolutely great - thank you so much. I'm really enjoying my PQ course and hadn't quite got to this stage yet. You were quite ri...
Hi Mynda, Good morning - for you. early evening here. I fully agree with your suggestion for the Mac tester; it was one of my politer thoughts,...