1 Reply Latest reply on Sep 17, 2013 10:05 AM by Pedro Machado

    Data Import Question: Collapsing Columns into a Single Dimension

    Robert Wyman

      We have a data file (think Excel) that has most of the data setup as columns.  These import easily.  However, the period (time) dimension is spread as columns (one date per column).

       

      Is there an easy way to import this using the standard Excel import and then convert or collapse all of the date columns into a single "period" dimension?

       

      Appreciate the help.