I'm trying to fill in Column A based on the info. listed in the first row for
a section. For example, column A would list Store 1 until it hit Store 2 and
then repeat until the next section.

Any ideas on how to do this??

Thanks!!!

Column A Column B
Store Detail Competitors
Store 1
Store 1 Detail Comp 1
Store 1 Detail Comp 2
Store 1 Detail Comp 3
Store 1 Detail Comp 4
Store 4 Store 4 Detail Comp 1
Store 4 Detail Comp 2
Store 4 Detail Comp 3
Store 4 Detail Comp 4
Store 4 Detail Comp 5