CODEWITHSUNDEEP
google-sheetsconcatenationtransposearray-formulasgoogle-sheets-query
iamthe202
iamthe202

Reputation: 39

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

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

Upvotes: 1

Views: 208

Answers (1)

player0
player0

Reputation: 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)); "♥")))

0

Upvotes: 3

Related Questions