How to concatenate two columns and append the result in new column or existing column

I have “First Name in column A” and “Second Name in column B”. I would like to concatenate these two columns with a space in between. Would you please suggest me which node to be used. I tried with Column combiner node and the it is not showing me the result as expected.

For Example - “Peter” in column A and “Parker” in Column B. I need my result to be “Peter Parker” in Column C

Kindly advice.