2 Replies Latest reply on Jun 10, 2016 9:47 AM by tom staab

    How can co-mingled data be broken apart?

    tom staab

      As an example, I have source data that contains the salesperson's name in a row of a spreadsheet along with product information rather than in a column of their own.  I need to display three unique columns of data.

      Please see the samples below.  Any advice?

       

      original source

       

      Product IDProduct
      Joe Smith
      2009-123laptop
      2009-321hard drive
      Sally Jones
      2009-456charging station
      2009-654headphones
      John Miller
      2009-789printer
      2009-987tablet

       

      how it currently looks in development

       

      Product IDProduct
      nullJoe Smith
      Sally Jones
      John Miller
      2009-123laptop
      2009-321hard drive
      2009-456charging station
      2009-654headphones
      2009-789printer
      2009-987tablet

       

      how it should display

       

      Product IDProductSalesperson
      2009-123laptopJoe Smith
      2009-321hard drive
      2009-456charging stationSally Jones
      2009-654headphones
      2009-789printerJohn Miller
      2009-987tablet