Create Columns based on values in Cells

[Rob48]

working in version 2021.4.2. I've seen similar discussions but haven't found one that quite answers my question.  

I'm trying to add columns to my data by taking values in cells and transposing them over, but I keep hitting walls. Seems easy enough but I can't figure it out.

in the below example I want to convert the values in the "Group" column into their own columns.

I want to turn this:

Employee Code	Group	Market
1	Accounting	N.America
1	Finance	N.America
1	HR	N.America
1	Legal	N.America
2	Accounting	Europe
2	HR	N.America
3	Accounting	Europe
3	Finance	Europe
3	Mfg	Asia
3	HR	Europe
4	Accounting	Asia
5	Accounting	N.America
5	Finance	Europe
5	HR	Asia
5	Legal	S.America
5	Mfg	S.America

into this:

Emp ID	Accounting	Finance	HR	Legal	Mfg
1	N.America	N.America	N.America	N.America	-
2	Europe	-	N.America	-	-
3	Europe	Europe	Europe	-	Asia
4	Asia	-	-	-	-
5	N.America	Europe	Asia	S.America	S.America

[binuacs · Accepted solution]

@Rob48 Use the Cross Tab tool

[Carolyn]

Hi! I got it to work with the Transpose tool (with Sort to get the Employee IDs in the right order). If that doesn't solve it, can you attach your workflow? 

[sarahmoe]

Hi there,

I understand you're working with Alteryx 2021.4.2 and facing challenges in transposing cell values into new columns. This can indeed be tricky. A potential solution is to use the Cross Tab tool. This tool can pivot your data, turning unique values in the 'Group' column into individual columns.

Here's a quick guide:

Input your data: Ensure your data is correctly inputted into Alteryx.

Select the Cross Tab Tool: Drag and drop the Cross Tab tool into your workflow.
Configure the Tool: In the configuration pane, set 'Group' as the new header field, and choose the appropriate data field (e.g., 'Employee Code') for the new column names.
Run the Workflow: Execute your workflow to see the transformed data.

Remember, the key is to correctly configure the Cross Tab tool to match your data structure. If you encounter any specific issues, feel free to share your workflow or a sample of your data for more tailored advice.

Hope this helps!

[sarahmoe]

Hi there,

I understand you're working with Alteryx 2021.4.2 and facing challenges in transposing cell values into new columns. This can indeed be tricky. A potential solution is to use the Cross Tab tool. This tool can pivot your data, turning unique values in the 'Group' column into individual columns. Here's a quick guide:

1. Input your data: Ensure your data is correctly inputted into Alteryx.
2. Select the Cross Tab Tool: Drag and drop the Cross Tab tool into your workflow.
3. Configure the Tool: In the configuration pane, set 'Group' as the new header field, and choose the appropriate data field (e.g., 'Employee Code') for the new column names.
4. Run the Workflow: Execute your workflow to see the transformed data.

Remember, the key is to correctly configure the Cross Tab tool to match your data structure. If you encounter any specific issues, feel free to share your workflow or a sample of your data for more tailored advice.

Hope this helps!