Split multivalue column into a row for each value in the same table

[NewPBIe]

Hello everybody. 

From this table:

id	Multivalue
1	A, B
2	A
3	B
4	A, B, C
5	C

I need this table:

id	Value
1	A
1	B
2	A
3	B
4	A

and so on. Thank you!

[Arul · Accepted solution]

@NewPBIe ,

In Power query editor try the below steps,

1. Split the multivalue column by comma delimiter by selecting split at Each occurrence of the delimiter,

2. Select the id column and do a right click and then do Unpivot Other Columns,

3. Delete the attribute column to get the desired output,

Thanks,

Arul

[NewPBIe]

Thank you @Arul!