''cannot output multiple independently repeated fields at the same time'' error upon querying

Question

There are four fields with multiple rows. I wish to append these rows. Is there a way to do it?

Sample data:

Answer 1

I see only two fields in your example
Below should work for them

SELECT
  Name, GROUP_CONCAT(Nickname) AS Nicknames
FROM Yourtable
GROUP BY Name