CODEWITHSUNDEEP
google-sheets-formula
Code Guy
Code Guy

Reputation: 3198

Merging row data based on a column value in Google Sheets

I have a sheet where I need to combine them based on same values of C column

Create a copy here Open the sheet here I have tried with '=QUERY(A2:I7,"select A,B,Max(C),D,E,F,G,H,I where A is not null group by C,B,A,D,E,F,G,H,I")

But that doesnt work. The expected results are shown in the image

enter image description here

Upvotes: 0

Views: 53

Answers (1)

W.S.
W.S.

Reputation: 1505

You can use:

=QUERY(A2:I7, "select A, B, C, max(D), max(E), max(F), G, max(H), I group by A, B, C, G, I")

Upvotes: 2

Related Questions