sherry64,
Because this is in the Excel Programming / VBA / Macros section, I'm assuming you want a macro.
Attached is an example workbook based on the criteria you described.
It has two sheets, 'Data' and 'Formatted for Mail Merge'
The Data sheet contains the original data with the columns you stated in your original post.
The 'Formatted for Mail Merge' starts empty.
In the 'Data' sheet there is a button labelled "Combine by Common ID for Mail Merge" which is assigned to the following macro:
When that macro runs, it will gather the data by common ID and display it in the 'Formatted for Mail Merge' worksheet as desired.
Does that work for you?
Bookmarks