How to combine multiple rows in unknown number of columns

BZeitner

Given the following input file where you don't know what years are in it:
id, year, status
1,1999,1
2,1999,1
1,2000,1
2,2000,2
1,2001,1
2,2001,2
1,2004,1

Desired output format:
id, status 1999, status 2000, status 2001, status 2004
1,1,1,1,1
2,1,2,2,null

Yoshiro_Fujimori

Here is one potential solution.

Cross Tab tool does most of the work.

If you stick to the column name, you may want to add Dynamic Rename tool.

Workflow

Output

I hope this answers to your question.

CrossTab.yxmd