Pivot Text Columns by initial row

[Anonymous]

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

[Anonymous · Accepted solution]

In Power Query:

1. Group the table by Emp ID and want all Rows:
2. 
3. Add a custom column with this code:

List.Accumulate(
[Count][Degree],
"",
(state,current)=> (state &", "& current)
)

1. It will produce a column like this:
2. 
3. Remove the [Count] column
4. Split the new Degree column by a comma, left most delimiter ( it will get rid of that inital comma)
5. Remove the blank column
6. Trim the degree column

FInal Table:

[Anonymous]

This worked perfectly! Thank you!

[Anonymous]

Awesome! Glad it worked 🙂