Merge cells similar to excel

[JP_1]

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

[JP_1]

Thank you all for your help and comments!

[JP_1]

Edited message