You’re offline. This is a read only version of the page.
Hello guys.
I'm actually blocked with my problem and can't find a solution that i understand with actual level on Power Query.
As you can see, i have a table that contains ids. In the cms_visitreportid, you can find at times the same id.
My goal is to have one unique line for each visitreportid but with all user_representativeid like below :
| cms_visitreportid | User 1 | User 2 | User 3 | User 4 | User 5 | User 6 | User 7 |
| XXXXXXXXX | x | x | x | x | x | x | x |
| XXXXXXXXX | x | x | x | x | x | x | x |
| XXXXXXXXX | x | x | x | x | x | x | x |
PS : In the table above, the "x" are representing "cms_cms_visitreport_user_representativeid" for each "cms_visitreportid" line. A single Visit Report can have a multitude of users so i can't just give a maximum number of columns.
Thank you in advance !
Hi,
Thank you very much it works like a clock !
Share
Report
All responses (
Answers (
834
