Splitting a table into several tables based on the value of an attribute so I can create a new table with the different attribute values as field names and counts. Or convert original table to one with additional rows for the attribute value counts.

Hi there, I have used a statistics calculator to group and count Shops on a streets by use - eg vacant, retail, leisure, financial etc. This gives me a table with the street name with different rows for the use and count of shops with that use on that street. Ultimately I would like to create a table with the uses as field names and the count of the use below with just the streets for rows.

So for example - Converting the table in grey to the table format below that. I am sure there is an easy way to do this! If anyone can help I would be very grateful.

Thanks Ruth