Dear all
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
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
09-Jan 88
10-Jan 17
11-Jan 57
12-Jan AMY
13-Jan 89
14-Jan 59
Bookmarks