Macro to combine three columns

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!