Forum Discussion
Solved
Fill a column with text only in the 1st cell of each unique row
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 t...
- 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
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
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