SELECT
Date,
MessageName,
MessageType,
MobileNumber,
CASE MessageName
WHEN MessageName = 'Text 1 Response'
THEN MessageText AS Text1Response
WHEN MessageName = 'Text 2 Response'
THEN MessageText AS Text2Response
END
FROM Responses_Report