Populate one single column with data from several columns UPDATE

[julianveda]

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

[FrederikE]

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. 

[ShankerV]

hI @julianveda 

One way of doing this.

Step1:  Input

Step 2: 

Step 3:

Step 4:

Step 5:

Last step:

Many thanks

Shanker V

[binuacs]

@julianveda Another option