Forum Discussion

bharukc's avatar
bharukc
Helper I
4 years ago

Pivot rows to columns multiple dates for same status

My data is like below

id. Status. Status date

1.   Active.  2/14/18

1.   Approved 2/15/17

1.   In review  2/19/18

1.   Active.      3/15/19

2.  Active.      2/15/19

2.  Approved.  3/19/19

2  Approved.   4/19/19

 

my result

id active.  Approved   In review  active.     Approved

1 2/14/18. 2/15/17.    2/19/18.    3/15/19

2 2/15/19.  3/19/19.    Null.           Null.     4/19/19

 

2 Replies