How to merge two columns in one

1

Hello,

I have two columns with two types of information and empty cells. I want to merge them in one column.

image

Thank you for your help

Karine

2

Hi Karine,

you can simply append the both columns using the text concatenation operator (&):

[Column 1] & [Column 2]
3

Hi Dmitry,

Thank you for response.

Have a nice day