Removing duplicates over multiple differently named columns

[kas]

Hello All,

The unique tool won't work in the scenario I have, and hoping to find another relatively simple way to do this. I'm looking to remove a duplicate within a given row, but the column headers are all different. So if in a row, a "Corrected By HR Id (1,2,3 or 4)" has the the same number  in it, to remove that number from the row. In the example below I need to remove in the row for id 2, to remove the number in the last column, and in the row for id 5, to remove the number in the Corrected By HR Id2 column.

Hope this makes sense...and thank you!

What I have
id	Corrected By HR Id1	Corrected By HR Id2	Corrected By HR Id3	Corrected By HR Id4
1	10006979
2	26997	10006596	10006979	10006979
3	10006979
4	10006979
5	10006979	10006979
What I want to have
id	Corrected By HR Id1	Corrected By HR Id2	Corrected By HR Id3	Corrected By HR Id4
1	10006979
2	26997	10006596	10006979
3	10006979
4	10006979
5	10006979

[IraWatt · Accepted solution]

Hey @kas,

Here is one way to do this using the transpose tool and summarize:

This solution uses the transpose and cross tab tools which can be hard to understand to new users. I would recommend checking out the community Getting-Started-Learning-Path for some context on how they work: https://community.alteryx.com/t5/Learning-Paths/Getting-Started-Learning-Path/ta-p/475117#done 

Any questions or issues please ask :)
HTH!
Ira

[kas]

@IraWatt 

This looks perfect...thanks so much!

[IraWatt]

No worries @kas glad it worked for you 😄