1 Reply Latest reply on Jul 31, 2018 7:39 AM by Mahfooj Khan

    Automate data Pivot

    Samarth pp

      Hi There,

       

      I've an excel source file, that has dates in the columns and trying to Pivot the data and bring dates to the rows (under one column header). Each month is in separate tab and doing wild card Union on tableau. Unable to do the following:

       

      1) pivoting dates in union

      2) how to automate the pivoting for future months?

       

       

      Attached is the sample source format, Looking to automatically bring dates into rows from columns.

       

       

      Appreciate any help.

       

      Thanks & regards

      Sam