This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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!