Breakout multiple items from a single cell into their own row

I have no idea how to get the Price Ea.

Please try Power Query
select original data > Ribbon data > from Table > Advanced editor > paste below code

Please Login or Register  to view this content.

Hi Bo_Ry:

Have a small quirk. Some of the P/N's do not have letters in them, just numbers: (such as 1047663). I should have included those in my example.

Excel is generating this error:

Please Login or Register  to view this content.

I've tried to change the date type to something else, but the error persists. Any thoughts?

EDITED NOTE: (I can place a TEXT qualifier in front of the P/N column in my table, copy, paste back as values, replace the original column and it works, but maybe there's a data type thingey that would do the trick in the code.)

Many thanks if you could take another look.

Pete

Please add a step to change P/N to text

Please Login or Register  to view this content.