will you please stop creating new threads with same content just because you didn't understand the replies you got (or you didn't explain what you wanted correctly)
this has already been discussed on https://www.sqlservercentral.com/forums/topic/case-statement-46
and on https://www.sqlservercentral.com/forums/topic/joining-2-select-results-into-a-single-row
if you need more/different info do follow it up in one of the original threads.