Hello. I received data from a supplier that captured all data in a single Excel file rather than segregating the values into their own cell. Please review the following sample and advise if the data in the fields can be segregated into different fields. For example, the results for Part Number, Market Place, and Applications should be:
I hope I understood the example correctly.
-
Concatenate all AttrValue grouped as follows and with separator "line break".
-
Pivot Data as described here:
I appreciate the feedback. I was able to transform the table by using the Split into rows action. Are you able to attach the EM project? Thanks!