CONCATENATE columns in numbers

"I have tried merge a row, It works perfectly."

That is a surprise,assuming you used a formula similar to the one that is shown and returns an error message.

My translation of that formula to fir a row: CONCATENATE(B6:F6) returned the expected Syntax Error message.

Syntax for CONCATENATE is provided in the Function Browser that opens in the right sidebar when you type = in a selected cell. Here's what it says for CONCATENATE:

ƒx CONCATENATE

The CONCATENATE function joins (concatenates) values or the contents of referenced cells. 

• CONCATENATE(string, string…)
  • string: Any value. 
  • string…: Optionally include one or more additional values or cell references.

Note that a list of values, not a Range of values, is specified for this function.

Applying that to your sample, the formula, placed here in B2 would be as shown below the table in the example below:

(The last token, and the comma leading it were included accidentally, and should be ignored.)

Regards,

Barry

If you are looking for a manual way to do it, like you were doing by merging cells in a row, here are some ideas.

If you merge cells in a row it will concatenate the cells with a tab between them but you end up with one big merged cell. Instead of doing that, select the cells, Copy, double click on the destination cell (to get into text entry mode), and Paste. This does the same concatenation all in the one cell. You can use Find/Replace to replace each Tab (Option Tab) with a space or a comma space or whatever but it is not much fun if you need to confine it to just this one cell (find & replace all will apply it to the entire document).

Doing the same thing with a column concatenates with an Option Return between each value. You can use Find/Replace to replace the Option Returns with spaces or comma spaces or whatever.

For columns, if you like the tabs between the values, transpose the table (Table/Transpose Rows and Columns) so columns become rows then and do like you would do with a row. Afterward transpose your table back like it was.

One way is to repeatedly add (concatenate) one cell to the previous...

Create a table. Enter the "bits" in the first column, and title a second column "Joined" (the name is not important).

Make the first row a header row by clicking on the "1" on the left and selecting the contextual menu item:

enter the bits values in the first column.

Now select cell B2 and enter the formula:

=A1

shorthand for this is B1=A1

now enter a formula in cell B2 as follows:

B3=B2&A3

this means select cell B3 and type (our copy and paste from here) the formula:

=B2&A2

now select the cell B3, copy

select cell B3 thru the end of column B, paste