Filling a range in Excel


In an excel file, I have data arranged as seen in the attached file.  I need to fill the value in Column A down to match where column B is populated until a new value occurs in Column A.  Then I need to use the next value in Column A and continue down until there's another new value in A.

In the attached, I'd fill "Air/Auto DC to AC Adapter" from Column A down from row 3 to row 18, then fill "Air/Auto DC to AC Inverter" from row 20 until another value is present.

Can someone point me in the right direction?



Who is Participating?
Rory ArchibaldCommented:
Select column A, press f5, then the Special... button, select Blanks from the options and press OK. Then press = followed by the up arrow, then Ctrl+Enter
Saqib Husain, SyedEngineerCommented:
Without VBA:

Select the entire data

Goto Data > Filter

Filter the column A to blanks only

if the first cell displayed is A3 the type this formula in it

and copy it down to the end of the list

Remove filters
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.