Hi Phil, Thanks very much - I should have spotted that myself but it often takes a second pair of eyes! Greatly appreciated. Pieter
Hi Phil, I think that's the approach I took in my "Modified" query which, as you say, is untidy. My real question is why this line: = Table.R...
Hi Phil, Thanks for a very prompt and helpful reply, as always. I had actually used both those options earlier and I agree that they are great f...
Hi Riny, Thanks for your post - I now have two ways of approaching the topic, which is fantastic! I'm still trying to get my head around M code, a...
Hi Mynda, Thanks - that's exactly the prompt I needed to get me going. I'll report back! Pieter
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 ...