I have a big list of items that unfortunately split the items into 2 rows but with differing values in different columns. Is there a way to combine them into 1 single row like this?

enter image description here

Any help much appreciated.


1 Answer 1


If there are never more than two rows with the same key value in column A, you can aggregate the data the way you describe with this formula in cell G1:

  "select A, max(B), max(C), max(D), max(E) 
   where A is not null 
   group by A", 

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.