Hey guys,

So here's the scenario.

I have a list that looks sort of like this:

EXAMPLE A XXXXXXX EXAMPLE A
EXAMPLE A XXXXXXX EXAMPLE A
EXAMPLE B XXXXXXX EXAMPLE B
EXAMPLE B XXXXXXX EXAMPLE B
EXAMPLE C XXXXXXX EXAMPLE C
EXAMPLE C XXXXXXX EXAMPLE C

The list about 1900 rows long. What I need to do is to find a way to automatically seperate and group each "Example" by name, that is, placing a row inbetween Example A and Example B, B and C so it looks like this:

EXAMPLE A XXXXXXX EXAMPLE A
EXAMPLE A XXXXXXX EXAMPLE A

EXAMPLE B XXXXXXX EXAMPLE B
EXAMPLE B XXXXXXX EXAMPLE B

EXAMPLE C XXXXXXX EXAMPLE C
EXAMPLE C XXXXXXX EXAMPLE C

And I need to do this every month when I run a certain report. Is there a way to have Excel automatically insert the rows for me? I doubt there is an "Insert Row" function, but is there possibly a way to do it in VBA? I've tried using macros, but that doesn't seem to do the trick.

Thanks so much!