On May 5, 4:55*pm, juliejg1
wrote:
I have a spreadsheet with column A and column B. *B contains different
supplier names. *Column A contains a region such as EU, NA, LA. *However the
region is only in the first cell of the list it matches in column B. *Just
like if I had created a pivot table from a list of data with region and
supplier. *Each region would only show once because the suppliers are being
grouped by region. *I need to be able to quickly copy down the region in
column A where there is a Region name above.

You can use a simple if statement to do this. Create a new column
labeled the same as your Column A
=if(isblank(cellA3),CellB2,CellA3)

A B C
Row 1 Region Type Region
Row 2 a 1 a
Row 3 2 a
Formual in C3 and down "=IF(ISBLANK(A3),C2,A3)"

You will need to seed the first cell with the actual value of "A2".
Then you drag formula down, copy column, paste special over your
original column A, then delete the column you created.