by Wyn Hopkins

The Challenge…

In this month’s challenge, you need to combine any non duplicate items into a single cell for each client ID#.

e.g. Client ID1 has 2 rows. All entries need to be combined to return 1 row for Client ID 1 so for example the two Phone Numbers: Phone 1 and Phone 2, these need to be combined into Phone1, Phone 2 in a single cell.

Submissions close 31st October 2023

 

Download the file

Sending us your solutions

If you’d like to submit your solution then please save you file as:

Your Name – Power Query Challenge – Group Uniques.xlsx (or PBIX if using Power BI) and send to info@accessanalytic.com.au

Please don’t send just M code.

Ideally make your solution flexible so that if more rows or columns are added your solution still works!

We’ll add your submission to our Submissions Folder.

Keep an eye out for Wyn’s solution on our YouTube channel.