How can I automate inserting dividers between groups?

Shirley December 11, 2011
Pinterest Stumbleupon Whatsapp

I have a list that contains a column with groups of numbers. I want to put a divider between each group. I usually just manually insert a row, but I’m looking for a way to use a rule or macro or something to do this quicker. Here’s an example:

12345
12345
12345
23456
23456
34567
34567

I want a divider between “12345” and “23456” and “34567”. It can be a row inserted, or divided by color, or whatever to distinguish one group from another. Thank you.

Ads by Google

  1. Anonymous
    December 11, 2011 at 3:05 am

    is it in word, excel...?