I have a wks for the description of stock items but the description is in 40
character groups so for one item number I have multiple rows, I need a way to
merge these rows into one cell per stock number.
example
Stock # description
s1 shoe, men
s1 style rbs
s1 color :brown

I need

s1 Shoe,men style rbs color brown