mikes6058
asked on
Split columns - Power Query
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
EE.xlsx