Quick, simple, down and dirty based on what you have revealed about the data.

SELECT SR.RoleName,

 'ManageBuyers'    = MAX(CASE AM.ModuleName  WHEN 'ManageBuyers'    THEN 1 ELSE 0 END),

 'ManageSuppliers' = MAX(CASE AM.ModuleName ...