Split Data in a column based on a Name field

Question

Hi All.

I have 2 column data or employees and allocated assignments.

I want to group the data such that the employee is in a single line, with all their assignments now appearing in columns in that employee record

Please see summary above of what I mean

Thanks

binu_acs · Accepted Answer

@UserUsh One way of doing this