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

    Import data in Aggregate form

    oshini.goonetilleke

      Hi

      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.

       

      Thanks!