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.