I think it may be possible to reshape, but may depend upon your type of datasource.
What is the datasource type for your zone-label data?
There may some possibilities in Tableau Prep.
Attached in the Forum Thread is an example reshaping in Excel using the Tableau Add-in:
281410format.xlsx 12.6 KB
Unfortunately, I am on a mac - and I am using a more recent version of Tableau which includes the Data Interpreter. I am using an Excel file so this might be on the right track.
Is Tableau Prep available with Tableau Public? Is there any other approach?
Ok, for Excel, I think the first step is to copy all your data as-is
and then paste in it a new sheet using the paste-transpose function:
It should then look like this:
Then you can pull the data in from this new sheet and use
the in-Tableau pivot function on the Datasource tab:
You might still need to turn on the Data Interpreter for Tableau to correctly recognize
You can then rename the "Pivot Field Names" as "Years" and switch it's type,
if needed, to a date. This is demonstrated in the workbook v10.3 attached in the forum thread.
I'm not completely sure how this will affect the joins to your spatial data.
If this doesn't work, would be grateful if you could post a small sample
of your spatial data file.
281410format.twbx 31.9 KB