Vertical Merge in Excel

Question

Hi everyone,
is there a way to merge cells vertically in this way:

We are talking about hundreds of cells.

Thank you,

Pietro

Answer 1

Hello Pietro,

there is no build-in function for it, but you can use formula like

=A1 & A2  
=B1 & B2  

you need to write only one formula, then simply drag it to the right.