Auto fill text columns based on rows
That worked!! thanks so much
"Gord Dibben" wrote:
Select column A then F5SpecialBlanksOK
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 specialvaluesokesc.
Gord Dibben MS Excel MVP
On Mon, 29 Mar 2010 11:46:02 -0700, Cecilia
wrote:
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
.
|