Exporting View with Values Populated for Each Row

Question

How to export a view from Tableau Desktop so that each column in a row contains values.

Environment

Tableau Desktop

Answer

Use the Copy option instead of Export:

Select Worksheet > Copy > Crosstab.

Open Excel or the desired spreadsheet program.

Paste the data into the spreadsheet.

Additional Information

By copying the view as a crosstab, and pasting the data into Excel, the full data behind the view in Tableau Desktop can be transferred to an Excel file, without merging cells that contain duplicate values.
Did this article resolve the issue?

Thank you for providing your feedback on the effectiveness of the article.