Hi guys,
I have data like so:
ReturnType | ReturnStatus |
CR | Sent |
CR | Not Yet Sent |
CR | Received |
CB | Submitted |
CB | In Progress |
CB | Sent |
CT | Rejected |
CT | Return Filed |
CT | Refund Pending |
CT | New Info needed |
CT | Rejected |
What Im trying to do is assign a group ID to each Return Type. I've tried a few different methods but sadly no dice.
The output I'm trying to achieve looks like so:
ID | ReturnType | ReturnStatus |
1 | CR | Sent |
1 | CR | Not Yet Sent |
1 | CR | Received |
2 | CB | Submitted |
2 | CB | In Progress |
2 | CB | Sent |
3 | CT | Rejected |
3 | CT | Return Filed |
3 | CT | Refund Pending |
3 | CT | New Info needed |
3 | CT | Rejected |
Many thanks in advance
Solved! Go to Solution.
@messi007 many thanks, I see what you did there i was just completely over thinking how to do it.
@Deano478 Another option is use the tile tool