Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'd like to pivot multiple text rows into one with a comma based on an employee column. Does anyone know how to do this?
I have the following table:
Employee ID
Employee Degree
It looks like this:
Emp ID | Degree
251 | Master of Science
251 | Bachelor of Arts
352 | Bachelor of Sciences
I'd like it to look like:
Emp ID Degree
251 | Master of Science, Bachelor of Arts
352 | Bachelor of Sciences
Solved! Go to Solution.
In Power Query:
List.Accumulate( [Count][Degree], "", (state,current)=> (state &", "& current) )
FInal Table:
In Power Query:
List.Accumulate( [Count][Degree], "", (state,current)=> (state &", "& current) )
FInal Table:
This worked perfectly! Thank you!
Awesome! Glad it worked 🙂
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |