Hi All,
Please refer to the below data. I want to derive the recordID column that is unique for every name.
Can you please help.
| Sl No | Name | RecordID |
| 1 | Apple | 1 |
| 2 | Apple | 2 |
| 3 | Apple | 3 |
| 4 | Orange | 1 |
| 5 | Orange | 2 |
| 6 | Grapes | 1 |
| 7 | Grapes | 2 |
| 8 | Brocolli | 1 |
| 9 | Brocolli | 2 |
| 10 | Strawberry | 1 |
Thanks