Populate one single column with data from several columns UPDATE

Question

Hi Community,

Could you help me in findin out how to put in a single column all the references that are scattered in several columns and that are sometimes repeated. In the image below I illustrate my case. What I would like to achieve is completing the colmn "Title 2" with the missing references that are in the other columns (Title 4, Title 5, etc) . The ides is to create a list with unique values as shown in the picture.

This post is actually a more complex case that the one already solved in:

Solved: Re: Populate one single column with data from seve... - Alteryx Community

Thanks for reading

binu_acs · Answer

@julianveda Another option

Title_230523.yxmd

ShankerV · Answer

hI @julianveda

One way of doing this.

Step1:  Input

Step 2:

Step 3:

Step 4:

Step 5:

Last step:

Many thanks

Shanker V

FrederikE · Answer

Hey @julianveda,

I have built a workflow that transposes it and then transposes it back again after removing empty cells and duplicates.

Start:

Result:

Hope this solves it.

New Workflow4.yxmd