Auto fill text columns based on rows

  • Thread starter Thread starter Cecilia
  • Start date Start date
C

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
 
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
 
That worked!! thanks so much

Gord Dibben said:
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



.
Click to expand...
 
Back
Top