Pivot rows to columns multiple dates for same status

[bharukc]

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

[tamerj1]

Hi @bharukc 

Can't you use a matrix visual?

[bharukc]

@tamerj1 ,

i want to creat gantt chart and use that layout for other calculations. I need it to be pivoted.