I forgot to mention that I am using SQLGridSelectedView V4.0

use this

SELECT     MAX(CASE WHEN propertyName = 'FirstName' THEN propertyValue END) AS FirstName,
                      MAX(CASE WHEN propertyName = 'LastName' THEN propertyValue END) AS LastName,
                      MAX(CASE WHEN propertyName = 'Company Name' THEN propertyValue END) AS CompanyName,
                      MAX(CASE WHEN propertyName = 'City' THEN propertyValue END) AS City, MAX(CASE WHEN propertyName = 'State' THEN propertyValue END)
                      AS State, MAX(CASE WHEN propertyName = 'Country' THEN propertyValue END) AS Country,
                      MAX(CASE WHEN propertyName = 'Postalcode' THEN propertyValue END) AS Postalcode,
                      MAX(CASE WHEN propertyName = 'telephone' THEN propertyValue END) AS Phone, UserRoles.RoleID, Roles.RoleName, Users.Email
FROM         (SELECT DISTINCT PropertyName, PropertyValue, UserID
                       FROM          ProfilePropertyDefinition AS ppd INNER JOIN
                                              UserProfile AS up ON up.PropertyDefinitionID = ppd.PropertyDefinitionID) d INNER JOIN
                      UserRoles ON d.UserID = UserRoles.UserID INNER JOIN
                      Users ON UserRoles.UserID = Users.UserID INNER JOIN
                      Roles ON UserRoles.RoleID = Roles.RoleID

GROUP BY d.UserID, UserRoles.RoleID, Users.Email, Roles.RoleName
ORDER BY UserRoles.RoleID