Data Set with multiple dates - needs calendar pivot table

[MiniFi]

Hi,
I've got a data set that looks like the below
Listing[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Company[/TD]
[TD]Listing 1[/TD]
[TD]Listing 2[/TD]
[TD]Activity a (1)[/TD]
[TD]Activity b (1)[/TD]
[TD]Activity a (2)[/TD]
[TD]Activity b (2)[/TD]
[/TR]
[TR]
[TD]Dan[/TD]
[TD]Dan's CDS[/TD]
[TD]Dan's Books [/TD]
[TD]Jan 30[/TD]
[TD]Feb 12[/TD]
[TD]April 9[/TD]
[TD]Jan 20[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD]Bob's DVDs[/TD]
[TD]Bob's Plates[/TD]
[TD]Jan 2[/TD]
[TD]March 8[/TD]
[TD]Jan 2[/TD]
[TD]Jan 30[/TD]
[/TR]
</tbody>[/TABLE]

I would like to be able to create a table from this data set that looks like the below:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]April[/TD]
[/TR]
[TR]
[TD]week 1[/TD]
[TD]Activity a / Bob's DVDs
Activity a / Bob's plates[/TD]
[TD][/TD]
[TD]Activity B / Bob's DVDs[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]week 2[/TD]
[TD][/TD]
[TD]Activity B / Dan's CDs [/TD]
[TD][/TD]
[TD]Activity A / Dan's Books[/TD]
[/TR]
[TR]
[TD]week 3[/TD]
[TD]Activity B / Dan's Books[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]week 4[/TD]
[TD]Activity a / Dan's CDs
Activity B / Bob's Plates[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


The data set is exported from a web program so I can make adjustments but I would rather keep these to a minimum where possible. I've worked with simple tables and pivot tables before but I just can't get my head around how to achieve this.

Thank you!