Not sure what is wanted. Try this and tell if it works
=A1&B1
or
=A1&" "&B1
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"iznogud" wrote in message
...
So,

the thing is I need to connect two columns into one, but in a way that it
puts one row from the first column, then a row from the second, and then
again from then first etc..
can that be done?