Macro to combine three columns

[bshelman]

Please excuse the blank cells/columns in this sample sheet. All cells/columns will have data entered into them, but I'm focusing on combining the data from columns C, I and L only. I need the combined column to "stack" (for lack of a better term) the corresponding cells from C and I (i.e. C2 over I2, C3 over I3, C4 over I4 then L2 (merged cell in some cases) at the bottom of the list. Please see the attached file for sample data.

A simple explanation of what I'm trying to accomplish... Each "name" (column C) is associated with a "Lot #" (column I). These lot #'s are then combined and sold as one "MASTER LOT" (column L) which is why I only need the associate Master Lot # listed once at the bottom of the list (top of list will suffice). I prefer the results to show on a separate sheet, but not a necessity.

Any help would be greatly appreciated! Thank you!

[Mumps1]

Try:

Please Login or Register  to view this content.

The data will be copied to Sheet2.

[bshelman]

SOOOOOOOOOOOO close, Mumps1.... The "name" and "lot #" are absolutely perfect, however there is only one "master lot #" showing in the list and it is at the very bottom... I need the "master lot #" to show listed directly under the related the name/parent lot #'s. Almost there! Thank you so very much for the help!

[Mumps1]

Try:

Please Login or Register  to view this content.

[bshelman]

PERFECT! Thank you Mumps1!!!!

[Mumps1]

My pleasure.