SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE formTypes (
   RecordID INT	,
   Name	VARCHAR(50),
   hasSpanishVersion VARCHAR(50),	
   Type	 VARCHAR(50),
   TypeID INT
);

INSERT INTO formTypes VALUES (1,'Test One','Yes'	,'FormType1',	1);
INSERT INTO formTypes VALUES (1,'Test One','Yes'	,'FormType2',	2);
INSERT INTO formTypes VALUES (3,'Test Three','No'	,null,	null);
INSERT INTO formTypes VALUES (4,'Test Four','Yes'	,'FormType3',	3);
INSERT INTO formTypes VALUES (5,'Test Five','Yes'	,'FormType3',	3);
5 rows affected

SELECT 
   RecordID, Name,hasSpanishVersion,
   STUFF((SELECT ',' + tt.[Type] 
          FROM formTypes tt
          WHERE 
          tt.RecordID = t1.RecordID AND 
          tt.Name = t1.Name AND
          tt.hasSpanishVersion = t1.hasSpanishVersion
          FOR XML PATH('')), 1, 1, '') as FormTypes
FROM formTypes t1
GROUP BY RecordID, Name,hasSpanishVersion
ORDER BY 1


RecordID
Name
hasSpanishVersion
FormTypes


1
Test One
Yes
FormType1,FormType2

3
Test Three
No
null

4
Test Four
Yes
FormType3

5
Test Five
Yes
FormType3


SELECT RecordID, Name,hasSpanishVersion,STRING_AGG([Type] ,',') 
FROM formTypes
GROUP BY RecordID, Name,hasSpanishVersion


RecordID
Name
hasSpanishVersion
(No column name)


1
Test One
Yes
FormType1,FormType2

3
Test Three
No
null

4
Test Four
Yes
FormType3

5
Test Five
Yes
FormType3

RecordID	Name	hasSpanishVersion	FormTypes
1	Test One	Yes	FormType1,FormType2
3	Test Three	No	null
4	Test Four	Yes	FormType3
5	Test Five	Yes	FormType3