Urgent - Splitting text from numbers in a column, please help

[hafiz_asim@hotmail.com]

Dear support,

here is the data which i need to split please guide.

Regards,

Data is formatted as follows.

Job Id

9580

9581

MAINTENANCE

8008_ABC

8009_ABC

8011_ABC

8012_ABC

8403_ABC

8806_ABC

INTERDIVISION - DISKs

4511_DEF

Required Out put in one column should be and rest in another.

MAINTENANCE
INTERDIVISION - DISKs

 

[Comfy]

Here you go:

let
    Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Job ID", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "ContainsNum", each List.AnyTrue(List.Transform(List.Transform({48..57}, each Character.FromNumber(_)), (substring) => Text.Contains([Job ID], substring))))
in
    #"Added Custom"

Then Filter by FALSE to show Text only
Filter by TRUE to show Jobs containing numbers.