Help on Transpose / Crosstab

[NJAlteryx]

Hi,

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

Below is my original data set:

Subject ID	Title Code	Title
56165	56165100	Physics
56165	56165200	Physics Advance
65746	65746100	Mathematics
46468	46468100	Biology
46468	46468200	Biology Foundation
46468	46468300	Biology Advance
76884	76884100	Chemistry

I will like my data to look like this after:

Subject ID	Title Code	Title	Title Code	Title	Title Code	Title
56165	56165100	Physics	56165200	Physics Advance
65746	65746100	Mathematics
46468	46468100	Biology	46468200	Biology Foundation	46468300	Biology Advance
76884	76884100	Chemistry

Can you please help me with the workflow 

Thanks in Advance,

nadia 

[alexnajm]

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

[abacon]

@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

[alexnajm]

Great minds think alike @abacon !

[abacon]

@alexnajm Yours is just a little quicker though.😂

Bacon

[jrlindem]

Well alright @alexnajm  and @abacon

Can't beat your speed and nothing more to add!  hahaha, nice work.

[jrlindem]

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