12 Replies Latest reply: Oct 12, 2018 11:22 AM by Lisa Valpassos RSS

    Convert date rows into date columns

    Lisa Valpassos

      Hi folks,

       

      I have a file with this structure (ignore dummy values):

       

      Rows_to_Columns.PNG

       

      And I simply want to convert the Date rows into various columns (one column for each year-month) because I have the requirement to see the data in a table with this format. I cannot use Pivot Table because pivot table does an aggregation (the Totals rows) that, for this purpose, is not accurate.

       

      I have tried the Generic Load but I'm not getting anything. I have to use a resident and preceding load with it and it keeps saying "Table 'myGenericTable' not found"

       

      Any help?

       

      Thanks!

       

      Lisa