Need help transposing data into columns from one column by finding duplicates

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!

Topic of Interest

Preparation

Accepted answers

JulioMO

Hi @CHolston32

No problem! Here goes the new workflow. Let me know if it works for you.

Regards

New Workflow2.yxmd

All comments

JulioMO

Hi @CHolston32,

The key Tool here is the Cross Tab Tool.

I attach a workflow that performs what you want.

Hope it helps!

Regards

New Workflow1.yxmd

CHolston32

Thank you! Trying this now, truly apreciate the workflow!!

CHolston32

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!

Alteryx Example Template.xlsx

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703