Help splitting values with commas

[cgkas]

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.

[cgkas]

@KNP Thanks so much for your help. in Power Query within excel is quite different but it works perfect.

[KNP · Accepted solution]

See below gif.

Take note of the 'Advanced Options', choose Rows.