Issue in achieving the desired output

[Rishabh94]

How do I use Alteryx Designer to arrive at my desired output?

Input - 

Input

Output - 

Output

[Robin_McIntosh]

What are the steps/process to get to the desired output?  Such as If/Then/Else, etc.  More info is needed to accurately answer.

[Rishabh94]

Hi, I don't have any prerequisite steps/processes to get this out. Just want to get my desired output using any Alteryx tools. I basically want to remove duplicates from columns Basic/Intermediate Skills, and the dataset I have is for multiple Names, just want to make sure of that as well

[cgoodman3]

To @Robin_McIntosh @point there needs to be some logic? For example you only want the first record for each basic skill but if the intermediate skill already exists to select the next option in the list?

I’d suggest looking at the inbuilt examples for the Unique tool and possibly also the join tool and that will guide you to a solution.