I have:
<b>parent_id   action      first_date   latest_date</b>
abc123   BuyerPriceLockPrice__c      9/30/2019    9/30/2019
abc123   BuyerBasis__c     9/30/2019    9/30/2019
abc123   GrowerCashPrice__c     10/10/2019    10/10/2019
abc123    BuyerCashPrice__c     9/30/2019   10/10/2019
abc123    Buyer__c       9/19/2019   9/19/2019
abc125    Grower__c     8/28/2019    12/16/2019
abc125    BuyerPriceLockPrice__c      6/26/2019    6/26/2019
abc125    GrowerPriceLockPrice__c      6/26/2019    6/26/2019
I need:
<b>parent_id   actionfirst date   action last date  actionfirst date   action last date  actionfirst date   action last date    
</b>
where each action either has a date or is null. There are a total of 12 actions.
<b>parent_id   action      first_date   latest_date</b>
abc123   BuyerPriceLockPrice__c      9/30/2019    9/30/2019
abc123   BuyerBasis__c     9/30/2019    9/30/2019
abc123   GrowerCashPrice__c     10/10/2019    10/10/2019
abc123    BuyerCashPrice__c     9/30/2019   10/10/2019
abc123    Buyer__c       9/19/2019   9/19/2019
abc125    Grower__c     8/28/2019    12/16/2019
abc125    BuyerPriceLockPrice__c      6/26/2019    6/26/2019
abc125    GrowerPriceLockPrice__c      6/26/2019    6/26/2019
I need:
<b>parent_id   actionfirst date   action last date  actionfirst date   action last date  actionfirst date   action last date    
</b>
where each action either has a date or is null. There are a total of 12 actions.