Help on Transpose / Crosstab

Question

Hi,

I am new to Alteryx and I am trying to use transpose / Crosstab.

Below is my original data set:

Subject IDTitle CodeTitle5616556165100Physics5616556165200Physics Advance6574665746100Mathematics4646846468100Biology4646846468200Biology Foundation4646846468300Biology Advance7688476884100Chemistry

I will like my data to look like this after:

Subject IDTitle CodeTitleTitle CodeTitleTitle CodeTitle5616556165100Physics56165200Physics Advance  65746 65746100Mathematics    4646846468100Biology46468200Biology Foundation46468300Biology Advance7688476884100Chemistry

Can you please help me with the workflow

Thanks in Advance,

nadia

alexnajm · Accepted Answer

This should work! Note you cannot have columns of the same name in Alteryx (and any other platform besides Excel)

abacon · Accepted Answer

@NJAlteryx Here is a way to do it.

The names will have to be slightly different due to Alteryx naming rules, but using the cross tab, some data prep, and then a transpose, you can get the output you are needing.

Bacon

jrlindem · Accepted Answer

Nope, sorry, I lied... I do have one change I would recommend for those that are on versions older than 2024:

I started with @alexnajm's file but swapped out the Record ID tool for a Multi-Row-Formula (because the old Record ID tool does not have Group by) so that I could group the Title's to avoid this:

and instead, get this:

But like the others pointed out, you will have to add a unique identifier to the column names since they can't be shared.  Hope this helps, -Jay