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!
