1 Reply Latest reply on Jan 28, 2019 7:06 PM by swaroop.gantela

    Combining Multiple Rows into Single Row

    Mike Arnett

      In my data set I currently have multiple rows with the same Order ID.  The first row with the same Order ID lists the primary product.  The other rows with the same Order ID lists supplemental supplies.  What I am trying to do is create a report which shows all of the primary products and underneath show the most commonly ordered supplies.

       

      Since the primary product is on a different row and the supplies are on different rows, I get a bunch of Null values.

       

      What I get is this:

       

      Order IDPrimary ProductSupplies
      12345Product1Supply3
      12345NullSupply1
      12345NullSupply4
      54321Product2Null
      65478Product3Supply2
      65478NullSupply4
      65478NullSupply3

       

       

      I want the data to look like this:

       

       

      Order IDPrimary ProductSuppliesSuppliesSupplies
      12345Product1Supply3Supply1Supply4