Grouping a column by type?

[carlwright1234]

Hi

I have a table of data:

Date, Type, Person 

10/10/2020, Booking, AJ

11/10/2020, Sale, AJ

11/10/2020, Booking, HA

12/10/2020, Note, AJ

12/10/2020, Note, HA

I would like to create a chart that lists date (months) across the columns and person on the rows with counts of each individual type split into the columns. I can't seem to work out though the route to take to split the type as a column (or if even possible) so I end up with:

             September                    October                       November

             Booking  Sale  Note      Booking  Sale  Note    Booking  Sale  Note 

AJ         0              0      0            1              1       1          0             0       0

HA        0              0      0            1              0       1          0             0       0

Is this possible?

Thanks for your help.

Carl

[amitchandak]

@carlwright1234 , Your expected output clear to me. Can you please explain with an example?

Appreciate your Kudos.