Forum Discussion
Help with Merging Two Columns based on 3rd column matching
Good morning. I have addresses of spouses that are on two different rows. I want to merge them into one row so ultimately I can create a mail merge for letters. So if the mailing address in column ...
=IF(E2=E3,CONCATENATE(A2&" & "&A3&" "&C2),"")
I would insert an additional column and enter this formula in F2 (in my example) and copy formula down.
OliverScheurich Thank you very much!