Hello all,

Just need a little help writing a macro that will merge two columns together. The coliums marked “Retained Notes” and “Frozen Notes” need to be merged into one column simply marked “Notes.” The text (if any) in both columns needs to be merged into one cell in a single column with a space between the text. “Retained Notes” and “Frozen Notes” are the headers in row one.

Retained Notes Frozen Notes
Notes1 Notes2

Becomes:

Notes
Notes1 Notes2