Re: Looking for automated way to build an event attendance list

Hi Randy340 ,

Follow the process to apply PQ:

• GoTo Data Tab ,
• Under Get & Transform Data, Click on Get Data , 
• On doing above, will give you some options, click on the 5th option(From Other Sources), which opens few more options --> Click on Blank Query,
• On doing the step above opens the Power Query Window. From there under Home Ribbon Tab, Click on Advanced Editor,
• Now, whatever you see in the editor completely delete and paste the m-code given by Maciej_Kopczynski and then click on Done, while doing all of these ensure to either have same table name as given in the code or just change the table name as per your data in the first line of the code, also the data should be in Structured References aka Tables and not range. 
• Below is a .gif showing the whole process. 

Power_Query