sql server - How to take data from row from an SQL query and show it in column in SSRS -

i have following design view in ssrs:

enter image description here

when previewed get:

as can see entity name appears twice 'group'. looking if there many entries per entity put them in same row in different column, this:

i using table display data.

how achieve result looking for?

maybe u can use workaround ? first use column named "category". using case function can give new name. after need order by function. example :

  ,case     when database.entityname '%group' 'xx group'     when database.entityname '%asx' 'xx asc'    end category

then use "category" in table , not "entity name".

this should make table following example :

last name - category - date of last credentialing - credentialing expired

same name - xx group - 10/01/2017 - 12/01/2017

same name - xx group - 15/01/2017 - 22/02/2017

same name - xx asc - 12/02/2017 - 05/03/2017

it not make columns in row, grouped if u use order by function. order last name, category,... if have dates yours.

HR