Forum Discussion
Replace all Distinct Values in a column
I have a column "Employee" that consists of many different employees repeated multiple times with the cooresponding projects they work on. ProjectID | Employee 123 John 456 ...
You could : use a duplicate of the table, remove all columns except Name, Remove Duplicates,
Add an Index column (from 1). Add a custom column "Employee" & Index number
You can then Merge that Query with the original on the name column to bring the EmployeeX text back
You could : use a duplicate of the table, remove all columns except Name, Remove Duplicates,
Add an Index column (from 1). Add a custom column "Employee" & Index number
You can then Merge that Query with the original on the name column to bring the EmployeeX text back
This worked, thank you!