Sum of unique values with mulitple criteria based on date :/

Hi,

I have the following data and am completely stuck at working something out:

ID	First Seen	Class Date	Class	Exercise Type
1234	01/04/2016	01/04/2016	a	Cardio
1234	01/04/2016	02/05/2016	b	Weights
1325	25/05/2016	05/06/2016	b	Weights
1658	01/08/2016	07/09/2016	c	Weights
4587	08/06/2016	08/06/2016	b	Cardio
4587	08/06/2016	01/07/2016	c	Weights
4587	08/06/2016	29/07/2016	a	Weights
1234	08/06/2016	29/07/2016	b	Weights

So... I am trying to find, for each "Class Type" the number of customers who took Class A first, Class B first and Class C first - AND the number who took Class A second, Class B second and Class C second; the results would be displayed similar to this:

.	CARDIO	CARDIO	CARDIO	WEIGHTS	WEIGHTS	WEIGHTS
.	A	B	C	A	B	C
1st Class Taken	1	1	0	0	1	1
2nd Class Taken	0	1	1	0	0	0

Any help would be massively appreciated on a formula - I'm well and truly beat