New answers tagged


Assuming the columns you have are C-G, entering =arrayformula({C2:C, D2:D & E2:E & F2:F, G2:G}) in the cell H2 will have the desired effect. The arrayformula indicates that in every row, one should have three entries: one from C, one is concatenation of D,E,F, and the last from G.

Top 50 recent answers are included