Excellent job posting the details. I just couldn't quite see what you were trying to do before.

Something like this should get what you want.

select UserId,

MAX(Case when Ugedag = 'Mandag' then Frakl + ' - ' + Tilkl else null end) as startSlutMandag,

MAX(Case when Ugedag = 'Tirsdag' then Frakl + ' - ' + Tilkl else null end) as startSlutTirsdag,

MAX(Case when Ugedag = 'Onsdag' then Frakl + ' - ' + Tilkl else null end) as startSlutOnsdag,

MAX(Case when Ugedag = 'Torsdag' then Frakl + ' - ' + Tilkl else null end) as startSlutTorsdag,

MAX(Case when Ugedag = 'Fredag' then Frakl + ' - ' + Tilkl else null end) as startSlutFredag

from example

group by UserId