Hi -
As an example:
I have 10k rows of employees (email address as unique identifier in column A) that are placed into certain groups, in column B. Some of these employees are duplicates because they belong to more than one group.
I need a workflow that will read Column A and search for duplicates and transpose the info in column B when it finds a duplicate.
Output:
Every row is unique, Column A is email addresses, and Columns B...C....D....E so forth are the multiple groups any one employee may have.
Thank you! Urgency is appareciated!
Solved! Go to Solution.
Hi @CHolston32,
The key Tool here is the Cross Tab Tool.
I attach a workflow that performs what you want.
Hope it helps!
Regards
Thank you! Trying this now, truly apreciate the workflow!!
Again thank you Julio! Looking at the Cross Tab tool, I think the workflow is "matching" the columns. But realistically, there are 45 groups and 3k+ employees so I cant have the groups across the columns and it "match" 😞 but instead, I DO KNOW that no single employee is mapped to more than 4 groups. So I am hoping to have the output with just 4 additional columns showing each group, transposed. I have attached an example, apologies I did not attach it before.
Any help is truly appreciated! Trying to get ahead of a client and work some Alteryx magic 🙂 THANK YOU!
This is beautiful, I cannot thank you enough!! Worked perfectly. Thank you!!!!