6 Replies Latest reply: Aug 6, 2016 12:03 PM by Sunny Talwar RSS

    How to group records

    michele manfrin

      Hi all

       

      I have a table like this:

       

      Order | State                 | Date

      A        | To be Receive  | 01/08/2016

      A        | Received          | 04/08/2016

      A        | Closed              | 05/08/2016

      B        | To be Receive  | 07/07/2016

      B        | Received          | 08/07/2016

      B        | Closed              | 09/07/2016


      I would to be able to obtain something like this:


      Order | To be Received | Received     | Closed

      A        | 01/08/2016        | 04/08/2016 | 05/08/2016

      A        | 07/07/2016        | 08/07/2016 | 09/07/2016

       

      Any ideas?

       

      Thank in advance

      Michele