Forum

Hi Catalin, Thanks for such an excellent solution, which is a real masterclass in so many ways. I'd forgotten about setting up the lists in the ...

Hi all, Power Query edit is now available on the MS Office 365 for Mac (Beta Channel) and it's really good. So far, the only top-level omission th...

Hi Greg, Thanks for mentioning this new property, which I hadn't spotted: it's really useful. For completeness, it doesn't require the second "Con...

Hi Mynda, Sorry for the late reply - I hate to leave things dangling, but life got in the way! Setting the print area and page breaks with VBA w...

Hi Mynda, Thanks for some more great suggestions. I don't have 365 and, sadly, most of the students don't have access to computers and we need to ...

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