Custom Report to export to Excel

I've created a custom report based on a Crosstab report to show Resources in rows and Work in the columns with the dates in weeks along the time period. Is there anyway to replicate this in the tables/views so that I could export the same data as the customised crosstab to excel? So far I have only managed to export using a customised task and resource map - but this does not give me the option to have the time period within the export.

At the moment I am copying and pasting hours per resource per task into Excel where we are keeping the equivalent of the customised crosstab report in order to provide the client with spend profiles with actual costs inserted.