Forum Discussion
help 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...
do you have a master list of sales people that aren't part of the transactional file?
vanessafvg this is the only file that I have & is system generated.
Or it can be done in Excel itself?
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?