SOLVED

Fill a column with text only in the 1st cell of each unique row

%3CLINGO-SUB%20id%3D%22lingo-sub-2741101%22%20slang%3D%22en-US%22%3EFill%20a%20column%20with%20text%20only%20in%20the%201st%20cell%20of%20each%20unique%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2741101%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20table%20of%20data%20coming%20into%20an%20excel%20sheet%20but%20only%20the%201st%20row%20of%20each%20unique%20value%20has%20a%20label%2C%20how%20do%20I%20fill%20down%20in%20excel%20such%20that%20as%20a%20new%20value%20is%20encountered%20it%20fills%20from%20that%20point%20to%20the%20next%20unique%20value%20and%20so%20on.%3C%2FP%3E%3CP%3Erow%201%26nbsp%3B%20%26nbsp%3B%20Product%20A%3C%2FP%3E%3CP%3Erow%202%26nbsp%3B%20%26nbsp%3B%20Blank%20(but%20want%20to%20fill%20as%20Product%20A%3C%2FP%3E%3CP%3Erow%203%26nbsp%3B%20%26nbsp%3B%26nbsp%3BBlank%20(but%20want%20to%20fill%20as%20Product%20A%3C%2FP%3E%3CP%3ERow%204%26nbsp%3B%20Product%20B%3C%2FP%3E%3CP%3ERow%205-10%20Blank%20(but%20want%20to%20fill%20as%20Product%20B)%3C%2FP%3E%3CP%3Eand%20so%20on.%26nbsp%3B%3C%2FP%3E%3CP%3EData%20set%20contains%20a%20lot%20of%20rows%20and%20multiple%20products%20with%20varying%20rows%20of%20data%20so%20not%20ideal%20to%20have%20to%20drag%20each%20section%20down%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2741101%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2741277%22%20slang%3D%22en-US%22%3ERe%3A%20Fill%20a%20column%20with%20text%20only%20in%20the%201st%20cell%20of%20each%20unique%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2741277%22%20slang%3D%22en-US%22%3EConsidering%20the%20first%20value%20of%20your%20column%20is%20%22Product%20A%22%2C%20select%20the%20whole%20column%20and%20apply%20filter.%3CBR%20%2F%3EThen%20you%20filter%20only%20the%20blank%20cells.%3CBR%20%2F%3EConsidering%20the%20first%20product%20is%20on%20Cell%20A1%2C%20you%20need%20to%20select%20all%20blank%20values%20of%20your%20filter%20and%20apply%20the%20formula%3CBR%20%2F%3E%3DA1%20and%20then%20press%20CTRL%2BENTER%3CBR%20%2F%3EAfter%20you%20can%20clear%20your%20filter%20and%20the%20magic%20is%20done.%3CBR%20%2F%3ERemember%20to%20copy%20and%20paste%20special%20values%20to%20replace%20the%20formula%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a table of data coming into an excel sheet but only the 1st row of each unique value has a label, how do I fill down in excel such that as a new value is encountered it fills from that point to the next unique value and so on.

row 1    Product A

row 2    Blank (but want to fill as Product A

row 3    Blank (but want to fill as Product A

Row 4  Product B

Row 5-10 Blank (but want to fill as Product B)

and so on. 

Data set contains a lot of rows and multiple products with varying rows of data so not ideal to have to drag each section down

1 Reply
best response confirmed by DJFinance22 (Occasional Visitor)
Solution
Considering the first value of your column is "Product A", select the whole column and apply filter.
Then you filter only the blank cells.
Considering the first product is on Cell A1, you need to select all blank values of your filter and apply the formula
=A1 and then press CTRL+ENTER
After you can clear your filter and the magic is done.
Remember to copy and paste special values to replace the formula