Split columns - Power Query

mikes6058
mikes6058 used Ask the Experts™
on
Hi

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
split-columns.xlsm
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Principal Systems Engineer
Top Expert 2005
Commented:
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

http://markvsql.com/2015/03/advanced-column-splitting-in-power-query/

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