Forum Discussion
Looking for automated way to build an event attendance list
I need to create attendance lists for events where several hundred tickets are sold. Some people buy a single ticket while others buy multiple tickets. Is there a formula I can use so that (in this...
Hi Maciej,
Your solution looks perfect for what I need. I am a tech idiot so I am not sure when I open my source table in Excel how I get to the PQ advanced editor in Excel and how/where I enter the code you provided. I don't know if my version of Excel could be the problem. It is Microsoft Excel 2016 MSO (Version 2401 Build 16.0.17231.20194) 32 bit. When I go into may account it says it is up to date. Thanks so much for your time.
Your solution looks perfect for what I need. I am a tech idiot so I am not sure when I open my source table in Excel how I get to the PQ advanced editor in Excel and how/where I enter the code you provided. I don't know if my version of Excel could be the problem. It is Microsoft Excel 2016 MSO (Version 2401 Build 16.0.17231.20194) 32 bit. When I go into may account it says it is up to date. Thanks so much for your time.
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
- Thanks so much for your more detailed instructions. I should be able to do this.