If column cell contains text return that text OR if blank return text from cell above

Don't know where to start with this one.
I have a work around but know there is a much better way to approach this.
I get a weekly report and I basically search for the 3 letter N7, N22, N44 etc.. there is 28k rows of data.

Basically I filter column N and remove the blanks. In R7 I code =N7 with returns ACD
Then I flash fill down.

Then I add in R8
=IF(N8="", R7,) So it's looking to see if N8 is blank if it is its It looks a row up and returns that value.
Flash fill Column R.

Anyway its crap code...

I know there is a better way to do what I want.

I just don't know if I am explaining it well enough
My uploaded file shows the old report and the Work is the way I would like it to look so I can filter Column R and look at a only ACD or ACE or AQD.

Hope you understand what I'm trying to accomplish?

TIA!!!

I'm not sure I understand what the actual problem is. If you put this formula in R7 and copy it down, I think it's what you want, but I think that's what you're doing already.
=IF(N7="",R6,N7)

Sorry, I need more clarification on what the issue is I think.

Gregb11, actually that's exactly what I was missing. I only had half the reference. =IF(N7="",R6) I missed referencing N7 again. so you code completed what I was missing. It was hard to explain exactly what I wanted to have happen but all worked.
Thanks for taking the time to resolve.

Great - glad I was able to help.