Forum Discussion
kokoro_1202
Helper I
Helper Ihelp on data transformation
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...
kokoro_1202Helper I
Helper Ihihi,this is the sample excel file
vanessafvg
Community Champion
Community Championdo 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?