11 Replies Latest reply: Feb 12, 2016 1:49 PM by Josh Chang RSS

    merge rows based on the value of field

    Josh Chang

      Hello,

       

      I'm looking for a better way to merge rows with the same SerialNumber based on the value of "Status".

      For example, this is the original table:

       

      SerialNumber

      Date

      Status

      1

      01/23/2015

      Inventory

      2

      07/08/2015

      Inventory

      1

      01/19/2015

      Ship Out

      3

      06/15/2015

      Inventory

      4

      06/15/2015

      Inventory

      5

      06/21/2015

      Inventory

      3

      06/18/2015

      Ship Out

      6

      06/21/2015

      Inventory

      7

      06/21/2015

      Inventory

      2

      08/15/2015

      Ship Out

      4

      06/19/2015

      Ship Out

      5

      08/25/2015

      Ship Out

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      And, I would like to make a table like this:

      SerialNumber

      Inventory Date

      Ship Out Date

      1

      01/23/2015

      01/19/2015

      2

      07/08/2015

      08/15/2015

      3

      06/15/2015

      06/18/2015

      4

      06/15/2015

      06/19/2015

      5

      06/21/2015

      08/25/2015

      6

      06/21/2015

       

      7

      06/21/2015

       

       

       

       

       

       

       

       

       

       

      Thank in advance.

       

       

      Best,

       

      Josh