Left side is data, right side is expected

How do I combine duplicate rows into one while keeping separate columns?

CodePudding user response：

One way to do that is with query(), like this:

=query( A3:H, "select A, max(B), max(C), max(D), max(E), max(F), max(G), max(H) where A is not null group by A", 0 )