Changing Power Query rows to columns on repeat cells.

Using power query is it possible to turn a table that looks like this.

Label 1 | Value 1
Label 1 | Value 2
Label 2 | Value 3
Label 2 | Value 4
Label 2 | Value 5

into

Label 1 | Value 1 | Value 2
Label 2 | Value 3 | Value 4 | Value 5

I was playing around with pivoting and transpose but couldnt figure it out.

Originally Posted by CK76

Assuming 1st column Header = A, 2nd column header = B

Load table to PowerQuery.

Group by [A], All Rows
Attachment 523210

Add custom column with formula:
=Text.Combine([Temp][B], ",")

Split column by delimiter ",".

Remove column [Temp].

Result:
Attachment 523211

Whoa! i had no idea you could reference the table like that. That is very cool. Thanks for your help!

You are welcome and thanks for the rep