Grouping a column by type?

Question

HiI have a table of data:&nbsp;Date, Type, Person&nbsp;10/10/2020, Booking, AJ11/10/2020, Sale, AJ11/10/2020, Booking, HA12/10/2020, Note, AJ12/10/2020, Note, HA&nbsp;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:&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;September&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; October&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;November&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Booking&nbsp; Sale&nbsp; Note&nbsp; &nbsp; &nbsp;&nbsp;Booking&nbsp; Sale&nbsp; Note&nbsp; &nbsp;&nbsp;Booking&nbsp; Sale&nbsp; Note&nbsp;AJ&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp;0HA&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp;0&nbsp;&nbsp;Is this possible?Thanks for your help.Carl

amitchandak · Answer

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

Forum Discussion

Grouping a column by type?

1 Reply

Related content

Transform columns / type

Grouping rows by Column and then updating Column

Create columns group

Grouping Columns

Matrix column not grouped