I have roles in column A and their corresponding entitlement in column B
I need a macro to pick the child role corresponding parent role
Role Entitlement
Role 1 Entitlement 7
Role 1 Entitlement 8
Role 1 Entitlement 9
Role 2 Entitlement 7
Role 2 Entitlement 8
Role 3 Entitlement 6
Role 3...