Merge Two Columns Based on Header

**MSmithson** · 10-22-2010, 01:44 PM

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

**davegugg** · 10-22-2010, 03:07 PM

I don't think you need code for this. Assuming Retained Notes is in Column A and Frozen Notes is in Column B, Copy down column C:

Please Login or Register  to view this content.

**MSmithson** · 10-22-2010, 03:10 PM

Thanks davegugg, this function is actually going to be used within a larger macro that performs several other functions with the merged columns, which is why I'm trying to automate the merging with a macro. Thanks.

**davegugg** · 10-22-2010, 03:26 PM

Ok, that makes good sense. Here is a code to use. You'll need to customize where the variables are initialized.

Please Login or Register  to view this content.

**MSmithson** · 10-22-2010, 05:29 PM

Thanks for your reply davegugg! Retained Notes and Frozen Notes are always next to each other but sometimes in different columns (G, H or I). This is why I want to use the header in row one "Retained Notes" and Frozen" notes to identify these columns, then merge them into a new column. The merging would start at row 2.