which tool can I use to combine 6 columns of part numbers into one column

[MikeFrancis1959]

I have an Excel file that has 6 or more columns of parts numbers based on a customer. Some of them may be the same and some may not and I would like to create a workflow that can take all the columns and create a new one. I have to do this monthly and the original file from Excel is already in Alteryx but using different tabs of data so using Alteryx bet better, what is the best tool to use?

Thanks,

Mike

[ScottLewis]

Can you show what the output should look like for your sample data? Combine can mean a lot of things. 

[binu_acs]

@MikeFrancis1959 Something like this?

[MikeFrancis1959]

Here is my file again with an example output. My end goal is to take all of the part numbers from all the customers and put them in one column whether they are duplicated or not. I can then remove the duplicates but this is what I am trying to do.

Mike

[binu_acs · Accepted solution]

@MikeFrancis1959 Updated workflow attached

[MikeFrancis1959]

I was expecting something more complex but you made this very easy, again thank you for your help on this workflow and others I have asked about!!!!