Thread: Can't get following data into pivot chart

Hi All,
Can you please help me get the following data into a pivot chart. Every time I click it, it says its not in proper format. This is because there are dates off to the left and groups as columns. Is there a nice way to get this into the format for pivot table? I simplid the example attached to 2 groups and 10 weeks, but the actual data is many many groups and many many weeks.

Image of problem and xlsx of problem is attached.

Thanks very much!

Thanks so much for your help. However It's not working. Here is my acutal data sheet attached. Thanks much.