Solved: Help splitting values with commas

cgkas · ‎02-21-2022

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.

KNP · ‎02-21-2022

See below gif.

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

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.

Proud to be a Super User!

View solution in original post

cgkas · ‎02-21-2022

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

KNP · ‎02-21-2022

See below gif.

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

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.

Proud to be a Super User!