Duplication of rows based on combination of strings

[atk]

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

[Luke_C · Accepted solution]

Hi @atk 

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

[DataNath · Accepted solution]

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

[atk]

Amazing!! Works for me, thanks both! :)