Forum Discussion
Need help with reshaping table
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 |
You can do this with the Split Column tool under the Transform tab.
Make sure to select Split into Rows under the Advanced options.
1 Reply
You can do this with the Split Column tool under the Transform tab.
Make sure to select Split into Rows under the Advanced options.