Sep 10 2021 11:59 AM
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
Sep 10 2021 01:16 PM
SolutionSep 10 2021 01:16 PM
Solution