s this possible using formulas?
A1 has Apple in it. A5 has banana in it. A 9 Has carrot. There are spaces between A 2- A4, A6-A8. I want new column (Starting at B1) to fill those blanks with val above. I have tried using offset and row numbers but can’t get it working so far.
Excel link below
Image link below:
Column A or 1 represents what my data looks like in image/excel
Column B represents what I want it to do in image/excel