One option is to have two sheets side by side on a dashboard, with the same row headers. On the second sheet, you can hide the row headers, and mimic a larger table with two sheets side by side. However, with 16+ columns, I'm not sure how easily this would fit on a dashboard.
Yeah this is the problem i'm having, trying to display it all in one flow. a lot of the data will be hidden if I include both sheets on the one dashboard.
The link that I posted isn't straight forward. Have you tried anything like this yourself before?
No. I have never needed anywhere near 16 columns in my view. Hopefully someone else will chime in.
Jonathan Drummey's blog post here, goes into a little more detail about how to create the same technique as described in the URL linked:
Hope this helps!
One problem with the multiple axis crosstab is that if you have differing levels of detail, Tableau can end up generating additional queries to the data source and make it slooowwww. If you're looking for a really wide table without too much complexity, you might use Joe Mako's suggestion in the comments of the original linked article to reshape your data so the columns are all members of the same dimension, then you can put that dimension on columns.