Unine Multiple Columns' Value Into One Column

[Maltaleb001]

Hello everyone,

I have a bit complicated workflow I am trying to build. The actual data has 5K rows and 23 fields. I will be showing dummy data to explain the issue and hopefully you can help me.

See the picture below. I want to take each columns' values and stack them above each other with the same order. Meaning at the end I will have only 2 columns (letters and values).

However, this can be done using the Formula Tool or Filter Tool. But the real challenge is I want to create a workflow where the next person do not need to change anything. Also, the next person even he will have the same data schema, but the number of columns, the name of the columns  and number rows will be different. 

Is there a way I can create a workflow to have the desired output without the need for configuration, or at least minimum configuration?

I would highly appreciate it if you can help.

[Luke_C]

Hi @Maltaleb001 

Here's an example of one approach:

1. Add record ID in case values in the last column are not unique
2. Transpose letter columns
3. Remove null/empty values
4. Update column names/remove unneeded fields.