Forum Discussion
Solved
Power BI Download - Mutiple rows into one row Huge data
Dear,
I have huge data in power BI which I wanted to download. I have part numbers vs model usage, ex one part number used on 100models. Similar I have over 210k parts vs model usage. I'm looking to have model usage in one signel row separated by commans
1. As is
| MODEL_NUMBER | PART_NUMBER |
| Model 1 | 12345 |
| Model 2 | 12345 |
| Model 3 | 12345 |
| Model 4 | 12345 |
| Model 5 | 12345 |
| Model 6 | 12345 |
| Model 7 | 12345 |
| Model 8 | 12345 |
| Model 9 | 12345 |
| Model 10 | 12345 |
| Model 11 | 12345 |
| Model 12 | 12345 |
| Model 13 | 12345 |
| Model 14 | 12345 |
| Model 15 | 12345 |
| Model 16 | 12345 |
Reqruied.
| PART_NUMBER | MODEL_NUMBER |
| 12345 | Model 1,Model 2, Model 3, Model 4,Model 5,Model 6,Model 7,Model 8,Model 9,Model 10,Model 11,Model 12,Model 13,Model 14
|
Thank You,
Santhosh
