Populate one single column with data from several columns

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

Transforming

Accepted answers

Yoshiro_Fujimori

@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.)

ToSingleColumn.yxmd

All comments

Yoshiro_Fujimori

@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.)

ToSingleColumn.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703