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
It can be also done in the same table:
1) group by Employee, use operation "All rows"
2) add index column
3) expand column with grouped rows
4) delete column with Employees' names