Combine Columns

[jlfromm]

I  have a workflow that I need to combine my Recip ID into one column then remove duplicates and count. I know how to remove the duplicates and count by how do I combine 

[ShankerV]

Hi @jlfromm 

You can make use of Transpose tool and combine those 3 RecipID using Summarize tool in the Transform palette.

While using summarize tool do not use Start, Separator or End in the Output field.

This will resolve your issue.

[ShankerV · Accepted solution]

Hi @jlfromm 

Tried to take an sample similar to your issue and proposing a easy possible solution

Split into different tables using Select and join using Union tool.

Here below is the input used and output derived. The rest doing removing the duplicates and count which you are already aware of.