Need help with reshaping table

[Anonymous]

Hi Community, 

Can please help me with reshaping data in Power Query or using DAX for following problem

I have table table in following shape, where challanges are inside one cell (Table-1). I want to split them by customer ID (see table 2) . I am not sure which is best place to perform either excecuting it in Power Query or use DAX for it.  I would really appreciate for any given help. 

Table -1 

Customer ID	Challenges
1	A,B,C
2	A,C
3	C,V

Table 2

Customer ID	Challenges
1	A
1	B
1	C
2	A
2	C
3	C
3	V

[AlexisOlson · Accepted solution]

You can do this with the Split Column tool under the Transform tab.

Make sure to select Split into Rows under the Advanced options.