Convert row values as columns in sql server : 

Table:-

CompanyID Lead   LeadManager
1          2         3

Required Output:-

CompanyID  Role           RoleID
1          Lead            2
1          Leadmanager     3

