How do I merge 3 to 7 cells with text strings such as:
A1= Baking Powder,
C1 = Chocolate powder
D1 = Soft Gel
The desired outcome is:" Baking powder, Chowder, Chocolate powder, Soft Gel, Chocolate"
I got an error with Transpose as soon as it encountered a 2-word...