I have this table here in which I’m trying to right a VBA that will take the products for each account and drop them into the Product Summary column.
For instance for the company on C2 ‘XYZ Inc’ their products are widget1 (H2) widget2 (I2) and widget4 (K2). I would like to transpose those values (ignoring the blanks) into column G. So cell G2 would have the product widget1, cell G3 would have widget2, and cell G4 would have widget4.
Same would be applicable for company on C5. Is there a VBA that would allow me to do that?
By: Michael Oslin