Split columns - Power Query

mikes6058 used Ask the Experts™

This query related to power query not excel - I do not want to use VBA or the "text to columns" function

how would I split data in one collumn like below so that the column splits take place when their is greater than one space between the end of one text/number string and the next.

See example of desired result below.

Before split

00200  RUST-OLEUM UK LTD                       0001          158743       26/ 3/15            51.40          10.28            61.68

After Split

see attached
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Principal Systems Engineer
Top Expert 2005
What is your delimiter ?

In absence of additional available at this point of time, I suggest you look at the following blog site to get some insight


Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial