I don't have Tableau open in front of me to test this out, but what if you simply turn off "display headers" for that Row Number field?
Thanks Christopher, but I really want to hide the entire row num column (data included) so I only export columns company name, company contact and address to excel.
Hey Susan -
How are you actually exporting to Excel? If you leveraging "Crosstab to Excel", you're not going to get want you want (repeating company names) even with the "Row" workaround:
This is the nature of exporting to CrossTab.
If you publish your workbook to Tableau Server, you can get rid of the row column altogether, and when you export as data, you'll get what you want:
If you want your data exported from Tableau Desktop as "Good 'ol rows and columns" (vs. a crosstab) consider using the Worksheet | Export | Data menu open in Desktop. It will export the worksheet as a table (vs. a crosstab) to Access database, which you then could leverage in Excel:
Thanks for all the posts but I am still having a similar issue. I am using RowNum in my data to sort on, it is required but I would like to hide it as it won't mean anything to the user. Is there a way I can simply hide this column but leave it within my table ie. as is used in sorting?
I know this is a super old post, but has anyone found a workaround for this or has it ever been solved? I'm having the same issue and any help would be appreciated!
** I can create a new post if needed **
I'd ask the same! Any work around?
Probably best to create a new one and this is pretty old and there are a few topics in here.
If you do workbook -> Copy -> Data and then just paste in Excel you will get the results you want without merged cells. The export as crosstab creates the merged cells.
If you are talking about the sorting field in this post, just right click on the header and uncheck show header to hide it from the table and preserve your sort. Note: this field will still show if you export the data.