Clean up data

[andresf]

Hi,

Can someone please help me with this?

I have this raw data:

PRODUCT	SALES REP
A	1 David
B	3 Jim
C	4 Jean
D	Maria
A	Paul
B	George

How can I eliminate these prefix values (1, 3, 4) that come from the raw data? Is it in Power Query?. The idea is to have clean data such as:

SALES REP

David

Jim

Jean

Maria

Paul

George

Thanks!

Andres

 

[alansidman]

Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Custom1 = Table.TransformColumns(Source,{{"SALES REP", each Text.TrimStart(_,List.Transform({0..9}, each Number.ToText(_)))}}),
    #"Trimmed Text" = Table.TransformColumns(Custom1,{{"SALES REP", Text.Trim, type text}})
in
    #"Trimmed Text"