Combine data from a column to a single cell

[Deepk]

Hi team,

I want to combine data from all the cells from a column in a single cell. All the data data should be separated by as separator (of my interest like pipe, slash, comma, dot, spaces or a value ).

Input -->>

Selected column data

tata

bata

mata

pata

gata

<tbody>
</tbody>

macro code generate an inputbox

inputbox

,

<tbody>
</tbody>

Output-->>

cell in second next row after last row
tata, bata, mata, pata, gata

I hope my query is clear. Please help. Thank you

 

[Fluff]

Are you happy using the solution provided by Joe4?

 

[Deepk]

Are you happy using the solution provided by Joe4?

Yes, and I modified your code as well. now both codes are working fine. thank you.

 

[Fluff]

Glad it's sorted & thanks for the feedback