select	userid,
	max(case recordtag when 1 then record end) as firstname,
	max(case recordtag when 2 then record end) as middleinitial,
	max(case recordtag when 3 then record end) as suffix
from	[YourTable]
group by userid