Hello,
I am new to Alteryx, and i think i should use Crosstab.
I am trying to transpose some data from rows to columns. My Unique data is 'Subject ID' and i want to copy two columns, title code and title into the next available column. all the example i saw only transposed one column but i need two columns transposed into one row.
below is my dataset, and how i will like my new table to look like.
Can anyone please help.
My original data:
| Subject ID | Title Code | Title |
| 123909 | 123909100 | Physics |
| 123909 | 123909200 | Physics Advance |
| 237802 | 237802100 | Mathematics |
| 242378 | 242378100 | Biology |
| 242378 | 242378200 | Biology Foundation |
| 242378 | 242378300 | Biology Advance |
| 242372 | 242372100 | Sociology |
What i want my data to look like:
Code
| Subject ID | Title Code | Title | Title Code | Title | Title Code | Title |
| 123909 | 123909100 | Physics | 123909200 | Physics Advance | | |
| 237802 | 237802100 | Mathematics | | | | |
| 242378 | 242378100 | Biology | 242378200 | Biology Foundation | 242378300 | Biology Advance |
| 242372 | 242378300 | Biology Advance | | | | |
Thanks in advance,
Nadia
