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
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.
hI @julianveda
One way of doing this.
Step1: Input
Step 2:
Step 3:
Step 4:
Step 5:
Last step:
Many thanks
Shanker V