In Power Query, I have a [RID] column set up that identifies the rows sequentially. I would like to remove the first UserID duplicate. Does anyone know how to write the formula in Power Query?
For example:
RID | UserID | Code
1 | 999999999 | Red
2 | 999999999 | Orange
3 | 888888888 | Red
For example:
RID | UserID | Code
1 | 999999999 | Red
2 | 999999999 | Orange
3 | 888888888 | Red