MS SQL PIVOT with text as Fieldtype

The trick is, that you cast the text/string into varchar and then you can use MAX as aggregation type to return the readable value.