If it's text values,

=A1&B1

or, if you want a space between them

=A1&" "&B1



"bakee" wrote:

I want the data in two columns need to be in one column without lossing data