split single rows into multiple rows- No delimeter

[PreethuSanthu]

I have data like this!

6674:SHELL6305:SHELL6357:SHELL7685:SHELL7772:SHELL1316:SHELL7598:SHELL7708:SHELL

I want to transform like below!

Col1	Col2
6674	SHELL
6305	SHELL
6357	SHELL
7685	SHELL
7772	SHELL
1316	SHELL
7598	SHELL
7708	SHELL

[ziying35 · Accepted solution]

let
    txt = "6674:SHELL6305:SHELL6357:SHELL7685:SHELL7772:SHELL1316:SHELL7598:SHELL7708:SHELL",
    split = Splitter.SplitTextByCharacterTransition((c)=> not List.Contains({"0".."9"},c),{"0".."9"})(txt),
    result = Table.FromList(split,each Text.Split(_,":"),{"Col1","Col2"})
in
    result

Hi@PreethuSanthu

If my code solves your problem, mark it as a solution