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
[TABLE="class: grid, width: 50, align: left"]
<tbody>[TR]
[TD]tata[/TD]
[/TR]
[TR]
[TD]bata[/TD]
[/TR]
[TR]
[TD]mata[/TD]
[/TR]
[TR]
[TD]pata[/TD]
[/TR]
[TR]
[TD]gata[/TD]
[/TR]
</tbody>[/TABLE]
macro code generate an inputbox
[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD]inputbox[/TD]
[TD],[/TD]
[/TR]
</tbody>[/TABLE]

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