Converting columns to rows with multiple fields

[orangebloss]

My input table has Resource types, companies and week numbers showing allocation of resources. I need to load the data so that I can chart by week the number of resources by type and company. I've tried using Crosstable but as I have more than one column I need to include I'm not getting the results I need.

The table:

The required result:

[henrikalmen]

Have you tried to follow "Example 3" in the documentation for crosstable?

[Sayed_Mannan · Accepted solution]

Hi, you can still use crosstable to achieve the desired result, you just need to leave the first two column.
here is the script that would work for you:

CrossTable(Week, Allocation, 2) // here 2 represent the no of column you want to skip.

Best Regards,

Sayed Mannan Ahmad