4 Replies Latest reply on Aug 6, 2018 5:40 PM by oshini.goonetilleke

    Import data in Aggregate form



      I have a aggregated data source from excel, a simplified version is shown below. The actual table is much more complex.


      Screen Shot 2018-08-06 at 12.31.06 PM.png


      I would like to cleanly retrieve data from this table, so that I can perform further analysis on the aggregated data.


      It is not easy to manually flatten the table before aggregation and I do not have access to raw data.