Duplication of rows based on combination of strings

Question

Hi Team,

This community has been really useful for me in learning Alteryx. I'm now facing a new challenge for which I would need your help. I have two columns (Column A and column B)  with each column containing multiple words. I'm trying to duplicate the records for every unique combination of each word in column A and B. I've attached an example of the raw data and what I want my output to look like as well.

Any help will be appreciated. :)

Kind regards,

Aishwarya

Combinations.xlsx

Luke_C · Accepted Answer

Hi @atk

You can do this by splitting to rows and then appending the data

DataNath · Accepted Answer

@atk a couple of Text-to-columns, splitting to rows on the '\s' (space) delimiter should get you these: