I feel like there is probably a tool that can easily do what I want, but for whatever reason I'm having a hard time finding it.
I'm simply looking to group and then number rows within the group. For example, in the below table i want to add a column called 'order num' that essentially numbers each item within the group.
| lookup id | product id |
| 100 | 5234 |
| 100 | 6987 |
| 100 | 4465 |
| 101 | 7899 |
| 102 | 6891 |
| 102 | 3233 |
So the final result would look like this:
| lookup id | order num | product id |
| 100 | 1 | 5234 |
| 100 | 2 | 6987 |
| 100 | 3 | 4465 |
| 101 | 1 | 7899 |
| 102 | 1 | 6891 |
| 102 | 2 | 3233 |
