Try http://www.asap-utilities.com

Free Add in

Once installed go to ASAP Utilities - Columns / Rows - Merge Column Data

Hope it helps you, sure helped me!


~Robert

"SITCFanTN" wrote:

I have a range of data that I'm copying from one WB to another however in the
original WB the prod desc and date are in diff columns..prod desc is in A and
date is in D. When I copy to the new workbook, I need to merge A and D
together. Is this even possible? Thanks