Not sure what you mean here. Wouldn't you use a table or a matrix in a SSRS report to contain the data?

After a report renders you have the option to export it to Excel. Click the icon that look like an old floppy disk and choose to export to Excel.

As mentioned this process could be automated with a subscription.

I will mention that any headers in SSRS should be in the header section (created at SSRS design time). Else this can merge columns in the Excel edition of the report.