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?