I have a table that looks like the following:
| ID | Company |
|---|---|
| 123 | ABC |
| 123 | DEF |
| 123 | ABC |
| 456 | ABC |
| 456 | ABC |
I want to insert a new column that tells me how many unique company's are associate with each ID. So ideally something like this:
| ID | Company | Count |
|---|---|---|
| 123 | ABC | 2 |
| 123 | DEF | 2 |
| 123 | ABC | 2 |
| 456 | ABC | 1 |
| 456 | ABC | 1 |
That way I can just filer out the 1 value and only have the 2 (or more) left to focus on. Any help would be appreciated!