help on data transformation

Question

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 &amp; product?There are many other columns &amp; 1000+ rows.&nbsp;Any help is grateful. Thank you.

vanessafvg · Answer

please provide the data in text format.

kokoro_1202 · Answer

hihi,this is the sample excel filehttps://gofile.io/d/9vc8K5

vanessafvg · Answer

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

kokoro_1202 · Answer

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

vanessafvg · Answer

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

Forum Discussion

help on data transformation

5 Replies

Related content

Data transform using power query

Eventhouse data transformation

Data Transformations

Table Transformation

Real time data transformation options