Merge multiple column data in single row

[Nitin Shardul]

Hi,
Please find attached file want to merge multiple column data in single row I have used A2&","&A3 But its very lengthy.
Please suggest if any other formula available.

Thanks

N3

 

[bobhc]

Why would you say the formula you have show is lengthy, just enter and double click for the formula to fill down.

 

[Nitin Shardul]

Sir
I need that in single column only,
Its taking 2 columns only if i drag it

 

[prasaddn]

Hi,

In your file, with existing formulas in B5, add the below formula in B6 and then drag down.

=B5&","&A6

The last row will have all in one cell.

Regards,
Prasad DN

 

[Nitin Shardul]

Excellent Logic
Thank You Sir

 

[Yashashri]

there is a repetition of the second value in every cell. is that how you want the data?


you could try concatenate formula for the same. however on a larger range it will be tedious

 

[Khalid NGO]

Hi Nitin,
Another option:
Press F2 and type the following formula:
=CONCATENATE(TRANSPOSE(A5:A43&","))
Do not press enter
Select formula using mouse click:
TRANSPOSE(A5:A43&",")
and press F9
remove curly brackets {} at start and end, and press enter.

Chandoo describe in details here:
http://chandoo.org/wp/2014/01/13/combine-text-values-quick-tip/

Regards,

 

[bobhc]

I wrote

just enter and double click for the formula to fill down.

Prasad DN wrote

and then drag down.

The difference is? Where do you get,

Its taking 2 columns only if i drag it

.