Avatar of mikes6058

asked on 

Split columns - Power Query


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
Microsoft ExcelMicrosoft OfficeASPMicrosoft ApplicationsVB Script

Avatar of undefined
Last Comment
Tom Farrar

8/22/2022 - Mon