MySQL 5.6

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

select @@version;


@@version


5.6.51


create table test(name varchar(20),fruit varchar(20));

insert into test values('Jon','Apple');
insert into test values('Jon','Orange');
insert into test values('Jon','Grape');
insert into test values('Mike','Apple');
insert into test values('Mike','Orange');
select name, group_concat(fruit SEPARATOR '\n') from test group by name


name
group_concat(fruit SEPARATOR '\n')


Jon
Apple
Orange
Grape

Mike
Apple
Orange