Splitting Field Help

Anweinbe

Hello,

I have a file that shows me sales by customers. However, the products they bought are all listed in a single field, which isn't very helpful. I attached a sample of my data in excel. 

In short, if you look at column G, each of the first few orders have one product. the last row has 2. What I would love is to have this broken out so I can run product quantity analytics. Ideally This record would be broken into 2 lines. The first product on one line and the next product underneath. I'm ok if all the other fields have duplicative information. 

Thanks so much in advance!

sample data.xlsx

ArnaldoSandoval

Hi @Anweinbe 

The attached workflow parses your column G product(s) twice:

• the first time uses the Text to Columns tool to parse the Product(s) column using comma between products, and split the columns in rows.
• the second time uses the Text to Columns tools parsing the Product(s) column on the × character (note, it looks like an x by it is not), spliting the column in two columns.
• It rename the column Product-1 to Quantity and Product-2 to Product using a select tool.

hth

Arnaldo

Data-Parsing-01.yxmd