Crosstab records based on column names

O_Vizzle

Hi everybody,

hope i can find an answer here. I googled the forum but couldn't find a solution. I would like to cross tab the first table grouped by the header names and choose weekNumbers as new headers. So make the table horizontal. 

I found a way to do this with one single column using the CrossTab Tool. But how can i apply this easily to multiple columns?

Thank you very much for your support guys!

Input Table

WeekNumber	Forecast 1	Forecast 2
12	56	111
13	66	254
14	21	654
15	23	56

Result table

WeekNumber	12	13	14	15
Forecast 1	56	66	21	23
Forecast 2	111	254	654	56

patrick_digan

@O_Vizzle Give the attached a shot. The key is to transpose and then crosstab using a record ID. 

transpose crosstab.yxmd