Metabase: The CSV download for a pivot table should be pivoted

[agilliland]

• I am using the Chrome browser.
• My computer's OS is Mac OSX.
• My Metabase version is v0.17.0

Currently if you run a query which displays a pivoted table of data in the browser then go to download the file you get a different set of results. This is confusing and inconsistent for users. If a table is going to be pivoted it should be that way in the CSV as well.

:arrow_down: Please click the :+1: reaction instead of leaving a +1 or update? comment

[rafaelveloso]

Even better, there should be an option when exporting a pivot table to CSV allowing to choose raw or pivoted data before exporting.

[tlrobinson]

Now that we support arbitrary column selections and reordering it should probably also match that.

[josteinaj]

Also an issue when exporting XLSX. This, combined with #7902, makes it difficult to use Metabase for creating the reports we need.