Comma separated append Power Query

[dorukturkoglu]

Hi All,

I have a table like below, and I would like the values separated by comma to be appended as new rows, is this doable in Power Query?

Existing table: 

Customer ID	Values
1	25,27,29
2	26,28
3	30

Expected Result:

Customer ID	Values
1	25
1	27
1	29
2	26
2	28
3	30

Thanks a lot in advance!

[Greg_Deckler · Accepted solution]

@dorukturkoglu Sure, split the column by comma and then select your first column and Unpivot other columns.