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 · Accepted solution]

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

[O_Vizzle]

This is amazing! Thank you very much for that!

One thing only: The last part where you cut the ID Records from the Names. How can i make sure to cut a 2 digit or 3 digit ID? 

Thanks a lot Patrick!

[patrick_digan]

@O_Vizzle Assuming none of your fields start with a number to begin with, you could change that formula to 

Regex_replace([Name],"^\d+","")

This would replace all the digits at the beginning regardless of how many there are.

[O_Vizzle]

Thats brilliant! Thank you very much!

have a nice day and start into the weekend !