من قبل
Ansab Khan , AVP / Unit Head - Digital HR Solutions , Meezan Bank Ltd
as far as i have understand your question, you are asking to merge value into one cell, this can be done through "concatenate function" by using &.
For you want to merge a1 and b1 then your formula in c1 would be like
=a1&b1
this would be appeared without space, with space formula would be like
=a1&" "&b1
i hope you will find this helpful