How to concatenate columns in Excel

[M_1]

Say I have two columns containing data in Excel. Column A contains 10 non empty cell and column B contains 12 non empty cells. How can I create a column C with 10 + 12 cells without specifically telling Excel to put cell B1 in cell C11. In other words I would like to concatenate column A and B into column C without knowing the number of non empty cells in A or B.

 

[Ibix]

I don't think you can in plain Excel. You can with macros, though. Range("A1").End(xlDown) will return the last occupied cell below A1 (End acts like control and the down arrow key, so careful that A2 isn't empty). You can get the row from there.

 

[stoomart]

Something like this?

https://support.office.com/en-us/ar...one-cell-81ba0946-ce78-42ed-b3c3-21340eb164a6