Copying down row to the next occurence in a different row.

[Rich]

Hi,

I've got a stack of data related to sales copied from an external source and
pasted into Excel.


The data is structured so that row 1 contains the name of a branch merged
acoss the columns, then rows 2 to X have sales data across various columns.
Then follows another row with a branch name. Each branch has a different
number of rows beneath it.

I've created a new column at Column A. I want this to be the branch name so
that I can filter and perform calculations. Luckily all the data in column B
starts with the word "sales", except those rows with a branch name. I'm
trying to figure a way to look at column B, and copy down Column A all the
way to the next occurrance of a branch name in B.

I hope this makes sense, any help appreciated.

 

[M Kan]

Under the first branch name (let's assume this is A1), write the formula =A1.
Copy the formula then highlight your data range for column A, go Edit: Go
To: Special: Blanks. Paste your formula, which should copy all of your
branch names.