hi everyone.
i have a system generate field that contain the product code that was sold by the sale person, however the product code and sale person are in the same column.
Is it possible to separate them in excel so that there is a different column for "AMY" & ALEX
gofile.io/d/pmA0il
Thank you.
Date Sale Person
01-Jan AMY
01-Jan 5
04-Jan 94
04-Jan ALEX
04-Jan 89
04-Jan 9
07-Jan 23
08-Jan ALEX
08-Jan 88
08-Jan 17
11-Jan 57
12-Jan ALEX
Final result look something like this?
i have a system generate field that contain the product code that was sold by the sale person, however the product code and sale person are in the same column.
Is it possible to separate them in excel so that there is a different column for "AMY" & ALEX
gofile.io/d/pmA0il
Thank you.
Date Sale Person
01-Jan AMY
01-Jan 5
04-Jan 94
04-Jan ALEX
04-Jan 89
04-Jan 9
07-Jan 23
08-Jan ALEX
08-Jan 88
08-Jan 17
11-Jan 57
12-Jan ALEX
Final result look something like this?