You need to apply Pivot option in Data Prepation like below.
Step-01 All DT are converted into Date format like blow
Step-2: Select all DT dates and select Pivot
Output Looks Like this
Exclude Nulls in the report, You will see expected results
Pivot Dates.twbx 264.0 KB
Data Source is not accepting Pivot option as I mentioned earlier.
Which data source are you connected ? SQL Server, Oracle or any other ?
I'm using oracle datasource and pivot is only available for excel source
It can done with Custom sql. Let me know if you're okay with that or you can also create a sp in oracle to transform the data and call it directly in tableau.