Conditional Count and Highlight Records

[ynwkm]

I have a column of categories.

How do I generate a result where it shows me NEW column(s) with the counts of each categories
...in addition to highlighting certain categories (e.g. "Math" and "English")?

Example Input:

RecordID	Category
1	History
2	Science
3	English
4	English
5	History
6	Math
7	History
8	Science
9	English
10	English

Example Output:

RecordID	Category	Math_Count	Science_Count	English_Count	History_Count
1	History	1	2	4	3
2	Science
3	English
4	English
5	History
6	Math
7	History
8	Science
9	English
10	English

Thank you!

[DavidP · Accepted solution]

You can only do the conditional colour with a report table tool like this

[ynwkm]

Thank you!