I have 2 columns that have the records like
Column A Column B
Bert Dallas
Bert Texas
Bert Male
Mary Houston
Mary Texas
Mary Female
and I would like to combine them into one row
Column A Column B Column C Column D
Bert Dallas Texas Male
Mary Houston Texas Female

I've tried to do it using if statement, But I don't know have to make them
into one line. Is there any excel function that allow me to do it? If not,
what should i do? Please advise.

Thank you for the help!