Forum Discussion
Creating an Excel formula
There are 2 sheets with each 4 columns. Type: Startsession or Presentation Method: Method A, B or C Number: Unique identification number which can occur multiple times Region: Region can occur mu...
Pieter23 Let me start by thanking arnel_gp for taking the time to create a workbook that replicates your data. It enabled me to, fairly easily, create the desired output with Power Query as you can see in the attached file. It may need to be optimized to fit your real life data, but it demonstrates what you can achieve without complex formulae.
If you are new to PQ, check out the link below. It's a good starting point to learn more about it.
Thank you Riny_van_Eekelen!! Makes life easier. Now I only have to learn how to use Power Query...