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
Solved! Go to Solution.
@atk a couple of Text-to-columns, splitting to rows on the '\s' (space) delimiter should get you these:
Amazing!! Works for me, thanks both! :)