Concatenate data from duplicate IDs into a single row in Google Sheets

Question

I'm collecting responses from a Google Form where each user has an ID and can send multiple form responses. I'd like to have only one row for each ID and concatenate multiple form responses into one row containing all that ID's data.

I illustrated my question in the link below.

Editable Sheet

Answer 1

try:

=ARRAYFORMULA(TRIM(SPLIT(TRANSPOSE(QUERY(QUERY(SPLIT(TRANSPOSE(SPLIT(QUERY(TRANSPOSE(QUERY(
 IF(C2:G<>""; "♦"&A2:A&"♥"&B2:B&"♥♠"&C2:G&"♥♠"; );;99^99));;99^99); "♦")); "♠"); 
 "select max(Col2) group by Col2 pivot Col1");;99^99)); "♥")))