Creating new column and values from existing column/row values

Question

I currently have:

QuarterQ_CategoryQ_DescriptionValueQ2petsdogs0.123456Q3petsdogs0.123456Q2petscats0.123456Q3pets cats0.123456Q2familymom0.123456Q3familymom0.123456Q2family dad0.123456Q3familydad 0.123456

but need the data to look like this:

Q_CategoryQ_DescriptionQ2 ValueQ3 Valuepetsdogs0.1234560.123456petscats0.1234560.123456familymom0.1234560.123456family dad0.1234560.123456

I am very new to Alteryx and am having a difficult time trying to move/separate these values. Any ideas would be great! Thanks!

Kenda · Accepted Answer

Hey @HBarkdoll! First you can use a Formula tool to change the value in your Quarter column using:

[Quarter] + " Value"

From there, use a Cross Tab tool and group by Q_Category and Q_Description. Use Quarter as the new column headers and Value as your new column values. Hope this helps!

gnans19 · Accepted Answer

Pivoting and aggregating would solve your issue. Attached workflow.

AmeliaG · Accepted Answer

Thanks for your question!

The tool you are looking for is called the 'Cross Tab' tool. Here is a very helpful 'Tool Mastery' article for this tool. Additionally, I've attached a workflow which uses this tool to achieve your use case using your sample data.

Hope this helps!