Forum Discussion
Solved
Help splitting values with commas
Hello to all,
I have a table like this in Excel
| H1 | H2 | H3 |
| CAR | D | 2 |
| AIRPLANE | D | 46 |
| TRAIN | E | 3,57,1 |
| TRUCK | H | 7 |
| BIKE | R | 923,11 |
How can use power query in order to split down the values in Header3 (H3) that have commas to get an output like this:
| H | H2 | H3 |
| Car | D | 2 |
| Airplane | D | 46 |
| Train | E | 3 |
| Train | E | 57 |
| Train | E | 1 |
| Truck | H | 7 |
| Bike | R | 923 |
| Bike | R | 11 |
Thanks for any help.
See below gif.
Take note of the 'Advanced Options', choose Rows.
