Download an Excel file in Matrix Format (not normalized)
So I have a matrix table setup, works fine. But when I have my users download the matrix as an Excel file, the downloaded data is no longer presented in the same way as the matrix.
The data has been normalized, which means the users will have to re-create the matrix via a pivot table.
It would be really slick if Microsoft did both on download, create a sheet with the raw data (normalized) and created a second worksheet with the original matrix visualization as a pivot table.
But if that's too much, just having a plain table in the original matrix format would suffice.
Kevin L commented
Mark Walter commented
I would also add that from a user standpoint it would be nice for them to be able to also print a matrix table from the service, in a report format, and get multi pages if necessary.