Split Data in a column based on a Name field

[UserUsh]

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 solution]

@UserUsh One way of doing this

[UserUsh]

Fantastic! Works perfectly. Thank you