SQL Server 2017 (Linux)

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table Table1 (ID int not null, Name varchar(10), Value varchar(10), moid int, Column1 int);
create table Table2 (Column1 int, Column3 varchar(10));
insert into Table1 values (1, 'Bob', 'Bob', 1, 1),(1, 'Bob', 'Bob2', 1, 1), (2, 'Sally', 'Sally', 1, 2), (3, 'Jane', 'Jane', 2, 3);
insert into Table2 values (1,'Value1'),(2,'Value2'),(3,'Value3');
7 rows affected

SELECT 
            MAX(t1.Name) AS Name, 
            STRING_AGG(CASE WHEN t2.Column3 = 'Value1' THEN t1.Value ELSE NULL END,',') AS Value1,
            STRING_AGG(CASE WHEN t2.Column3 = 'Value2' THEN t1.Value END,',') AS Value2,
            STRING_AGG(CASE WHEN t2.Column3 = 'Value3' THEN t1.Value END,',') AS Value3
            FROM Table1 t1
            LEFT JOIN Table2 AS t2 ON t1.Column1 = t2.Column1
            GROUP BY t1.moid  ;


Name
Value1
Value2
Value3


Sally
Bob,Bob2
Sally
null

Jane
null
null
Jane


SELECT 
            t1.ID AS `ID`,  
            t1.Name AS `Name`, 
            group_concat(IF(t2.Column3 = 'Value1',   t1.Value, NULL)) AS `Value1`,
            group_concat(IF(t2.Column3 = 'Value2',   t1.Value, NULL)) AS `Value2`,
            group_concat(IF(t2.Column3 = 'Value3',   t1.Value, NULL)) AS `Value3`
            FROM Table1 t1
            LEFT JOIN Table2 AS t2 ON t1.Column1 = t2.Column1
            GROUP BY t1.moid  ;
Msg 102 Level 15 State 1 Line 2
Incorrect syntax near '`'.
Msg 102 Level 15 State 1 Line 4
Incorrect syntax near ','.
Msg 102 Level 15 State 1 Line 5
Incorrect syntax near ','.
Msg 102 Level 15 State 1 Line 6
Incorrect syntax near ','.