Split Alphanumeric column into 2

[Nivedhana]

We have a column capturing data in below format. Is it possible to split the text and numbers in 2 different columns in power query editor?

ABC

1

2

Bhy

3

[AlienSx · Accepted solution]

    r = Table.TransformColumns(
        Source, 
        {"ABC", (x) => 
            [num = try Number.From(x) otherwise null,
            txt = if num = null then x else null]}
    ),
    expand = Table.ExpandRecordColumn(r, "ABC", {"num", "txt"})

[slorin · Accepted solution]

Hi,

Another solution

= Table.SplitColumn(
   Source,
   "ABC",
   (x) => if Value.Is(x, type number) then {x,null} else {null,x},
   {"Num", "Text"}
 )

Stéphane 

[Nivedhana]

Thank you very much!! It worked!

[AlienSx · Accepted solution]

    r = Table.TransformColumns(
        Source, 
        {"ABC", (x) => 
            [num = try Number.From(x) otherwise null,
            txt = if num = null then x else null]}
    ),
    expand = Table.ExpandRecordColumn(r, "ABC", {"num", "txt"})