help on data transformation

[kokoro_1202]

hi all,

I have a excel file which contain the sale person name and the product they sold in the same column.

Is there a way to separate so that the column are sale person & product?
There are many other columns & 1000+ rows.

Any help is grateful. Thank you.

[vanessafvg]

please provide the data in text format.

[kokoro_1202]

hihi,this is the sample excel file

https://gofile.io/d/9vc8K5

[vanessafvg]

do you have a master list of sales people that aren't part of the transactional file?

[kokoro_1202]

@vanessafvg this is the only file that I have & is system generated.
Or it can be done in Excel itself?

[vanessafvg]

when you say can it be done in excel, i think you could possibly do this in power query in excel the only difficulty here is coming up with a set of rules or the pattern.

but there doens't seem to be a clear pattern, ie. products only being in number and names being in alpha characters.  There is also variations in the intervals.  So its actually quite difficult to come up with a solution that will work for every scenario.  What system do you get this from and are you able to pull out products and sales person separately?