Creating a new summary table

[ed_cosanto]

Hi,
I need to summarize this table, per protocol and status date, can help me?

id	Protocol	Stage_id	Status	Status_Date
1	100	1	a	10/15/2016
2	100	1	b	10/15/2016
3	100	2	c	10/17/2016
4	100	3	d	10/17/2016
5	100	4	e	10/17/2016
6	100	5	f	10/20/2016
7	101	1	a	10/15/2016
8	101	1	b	10/15/2016
9	101	2	c	10/18/2016
10	101	3	d	10/18/2016
11	101	4	e	10/19/2016
12	101	5	f	10/20/2016

Thus:

Protocol	a_date	b_date	c_date	d_date	e_date	f_date
100	10/15/2016	10/15/2016	10/17/2016	10/17/2016	10/17/2016	10/20/2016
101	10/15/2016	10/15/2016	10/18/2016	10/18/2016	10/19/2016	10/20/2016

Thank you.

[BeaBF]

@ed_cosanto hi! @MattAllingtonwrote well, accepts his answer as a solution. But I'll show you how to do it:

1. Choose matrix view

2. Enter the fields indicated by the colleague:
Rows> Protocol
Columns> Status
Values> Status Date

in this way:

you will get the desired result:

If you want to give me a like!

BF

[MattAllington]

Add a matrix

protocol on rows

status on columns

date in values (max)