Forum

Hi Mynda, Thank you! I took a look at the applied steps and saw that you tackled this by creating a conditional column on the end. I'll familiar...

File containing raw data and a worksheet showing the desired result attached.

Hi Mynda, The cells are not merged. Yes, I did turn the data into an Excel Table and then imported into Power Query. (see screenshot below). ...

Hi Mynda, I did watch this tutorial, particularly the part on Nested Column Headers. However, my case seems to be a little different because the he...

Mynda - you're amazing!! As soon as I changed the Locale to English (Australia) it worked!! THANK YOU!! Happy for this thread to be closed no...