Formatting 3 column array in Google Sheets with unique counts-CodePudding

Home > Software engineering > Formatting 3 column array in Google Sheets with unique counts

Formatting 3 column array in Google Sheets with unique counts

Time：10-08

I have the following data and the work-in-progress formula

=ARRAYFORMULA({unique(A2:A);flatten(UNIQUE(filter(C2:C, A2:A=A2))&": "&countif(filter(C2:C, A2:A=A2),UNIQUE(filter(C2:C, A2:A=A2))))})

How can I go about creating the DESIRED OUTPUT from the dataset?

Google Sheet link: