Moving random cells to another column

[Eqa33]

I have a column in power query showing a description ABC and listed below is a stock ID number 123, then 30 cells later EFG and 456 appears 50 cells later HIJ followed by a random amount of 789 until the next change.
How do I get a new column showing the Descriptions (ABC) etc and the numeric numbers remaining in the original column?

Thanks for your help.

Eqa

 

[GraH]

You are most welcome. Glad Alan and myself could help you.

Enjoy the learning. PQ is sheer power.