Hello everyone
I'm wondering how to automatically insert blank rows based on this:
I have company names, about 50. There is about 2,000 lines of data after it's all sorted
So it will be like:
----------------
Microsoft
Microsoft
Microsoft
Apple
Apple
Apple
Apple
Yahoo
Yahoo
Yahoo
Yahoo
----------------
If the company names are say... in Row Q, how would I automatically insert 6 blank rows at the point where the company names changes?
Thanks so much guys.
I'm wondering how to automatically insert blank rows based on this:
I have company names, about 50. There is about 2,000 lines of data after it's all sorted
So it will be like:
----------------
Microsoft
Microsoft
Microsoft
Apple
Apple
Apple
Apple
Yahoo
Yahoo
Yahoo
Yahoo
----------------
If the company names are say... in Row Q, how would I automatically insert 6 blank rows at the point where the company names changes?
Thanks so much guys.