CODEWITHSUNDEEP
arrayssortinggoogle-sheetsgoogle-sheets-formulagoogle-sheets-query
Zach Desjardins
Zach Desjardins

Reputation: 11

Grab data from multiple columns and sort by row in Google sheets

I'm trying to sort a google form response sheet with multiple duplicate responses into one set of responses, but still having it associated with the info in the first column. Here is a sheet with the basics of what I want to do.

Upvotes: 1

Views: 80

Answers (1)

player0
player0

Reputation: 1

use:

=QUERY({A:C; A2:A, D2:E; A2:A, F2:G}, "where Col2 is not null order by Col1", 1)

0

Upvotes: 1

Related Questions