In Microsoft Excel, how do I get the contents of multiple cells in one column into one cell horizontally?

Question

The Transpose function almost does this but it puts the data in multiple columns and I need it to go in one cell

Answer 1

Use the CONCATENATE function.

=CONCATENATE(A1,B1,C1,D1)

if you need spaces between, just use the formula this way:

=CONCATENATE(A1," ",B1," ",C1," ",D1)

The formula can be done without the function like:

=A1&" "&B1&" "&C1&" "&D1

Answer 2

it could be achieved by technique of splitting the cells. As you do not say which excel version you've i visit't allow you to comprehend the position the instructions are yet the following is a hyperlink to allow you to comprehend techniques that is achieved.

Answer 3

How many columns you have?
Is it a variable number of columns or is it constant?

I need more info

From the first look, you can use this
=INDIRECT( "A" & ROW()+1)
to get the first item, but i still need more info

VBAXLMan

Answer 4

use the merge and center command in the object bar... you can change the direction of the font by right clicking the cell after you merge it and setting the alignment under the format cell option.