I appreciate the assitance in
I have column A : names of companies any particular company might be repaeated
any where in the column.
I need to
1-copy the same data in the range A3-G60 into Sheet B
2-Sorted by company entry.
3-After each company string of entries there should be an empty row, this to include a en empty row in the begining
3- in each of the empty rows cells from column b-g will be merged
4- content of the merged cells will be the company name that follow below
5- please see my screen shot of the final look