Hi there - I was hoping someone could help with a problem I am facing. I have some data which I am combining, where Personnel may feature on more than one row. I want to add a new column (which I know how to do) to be completed offline out of Alteryx but I want the cells in the column to be merged to one cell for each Personnel, exactly like the Cleared [Yes/No] column below. It is because the Cleared column will be populated manually out of Alteryx and the entry going into that column (i.e. Yes or No) applies to each individual rather than each Client/Contract. Therefore, I am trying to avoid a situation where we manually have to drag entries down that column as Personnel could appear thousands of times. Appreciate any help that people can provide.
| Personnel | Personnel ID | Client | Contract Name | Cleared [Yes/No] |
| JP | 123 | Client1 | Contract1 | |
| JP | 123 | Client1 | Contract2 |
| JP | 123 | Client2 | Contract3 |
| XG | 562 | Client3 | Contract4 | |
| XG | 562 | Client3 | Contract5 |
| XG | 562 | Client1 | Contract2 |
| XG | 562 | Client3 | Contract5 |
| XG | 562 | Client4 | Contract6 |
| IA | 901 | Client2 | Contract3 | |
| AC | 492 | Client1 | Contract2 | |
| DG | 674 | Client5 | Contract7 | |
| DG | 674 | Client5 | Contract8 |
| DG | 674 | Client5 | Contract9 |
