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
https://www.dropbox.com/s/gtou…evious%20Column.xlsx?dl=0
Image link below:
https://www.dropbox.com/s/18dlgfcubdm5mfu/Excel.png?dl=0
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