Auto fill text columns based on rows

[Cecilia]

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

 

[Gord Dibben]

Select column A then F5>Special>Blanks>OK

Type an = sign in active blank cell then point or arrow up to cell above.

Hit CTRL + ENTER

With column still selected, copy and in place, paste special>values>ok>esc.


Gord Dibben MS Excel MVP

 

[Cecilia]

That worked!! thanks so much

Select column A then F5>Special>Blanks>OK

Type an = sign in active blank cell then point or arrow up to cell above.

Hit CTRL + ENTER

With column still selected, copy and in place, paste special>values>ok>esc.


Gord Dibben MS Excel MVP



.

 

[Gord Dibben]

Happy to help

Thanks for the feedback

That worked!! thanks so much