Populate one single column with data from several columns

[julianveda]

Hi Community,

I wonder if you could help me with knowing how I could put in a single column several information that is distributed across several columns.

See the image below to understand the example of the existing information (before) and the expected result (after).

Thanks for your time

Julian

[Yoshiro_Fujimori · Accepted solution]

@julianveda ,

Here is one way of doing this.

Workflow

After Transpose tool, update all the column names to "Title 2", so that Cross Tab tool can put all the value together.

Output

The order changes from the original data.

If you want to keep it, you may want to add record id first and sort with the record id at the end.

(Or sort with column 2, if that is the correct order.)

[julianveda]

Thank you! exactly what I needed :) 

[julianveda]

Hello again community,

I realized that actually my case was a little bit more complex than initially stated. What I actually have is :

As you can see I have the same term repeated in several columns and I would like to create a single column as shown in the image. When doing the solution proposed by  Yoshiro, that worked very well in my first case, I obtained a single column but with repeated values and I would like to create a list with unique values as in the figure above. would you have any ideas I might test to do this ?

Thanks for reading,

julian

[Dina]

The "Unique" tool should be able to do the trick.