excel - How to concatenate multiple columns having n no of rows -
i'm trying concatenate 2 columns having multiple rows. formula or command steps should follow following:
col1 col2 john smith denial vos
i'm trying results like
col1 john smith denial vos
you use concatenate function. this:
=concatenate(a:a," ",b:b)
.
Comments
Post a Comment