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
<tbody>
</tbody>macro code generate an 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
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>
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