Hello experts,

I need your help to convert the data in a tabular format to that of a matrix as mentioned below.

Existing format

Name Role
Mac Employee
Robert Employee
John Manager