Guys,
I have a pretty unique situation in one of my very big excel files and I am really forward to your help. The file basically has 3 columns. Column A - ProductCode, B - ProductName and C - Description (A sample of the data is attached to this question). The Descriptions are in multiple line for each product and I need them to be on one line with a space or comma between them. The Descriptions sometimes might be on two lines, sometimes three, four, five, etc. The only way to know where to end joining the description will be a blank row/cell at the end of each new.
I will dearly greatly appreciate any of your help.
Cody
Start Free Trial