I was trying to use @FILTER but it looks like after I ran my Macro it is not working?

[RudeBoy]

This is the result I have NOW after I ran my Macro -

The results I needed were this that was present before is this:

The data in column A & B will not always be in the same line number it could vary but I need to capture only the Data over to Rows E & F.
Not sure if there is a Formula way to do this or a VBA way?
Here is what result I am looking for:

Thanks for any & all help

 

[Fluff]

How about

=FILTER(A1:B1000,A1:A1000<>"")

 

[RudeBoy]

How about

=FILTER(A1:B1000,A1:A1000<>"")

That works Great but again when I run my other Macro it makes the =@FILTER not give the Proper result. Very Weird.

Let me explain the process.
I have a Macro that renames = to /= which de-activates all my formulas.

Normally I would do this manually but now with up of the board I have two macros to do this in a click.

I called then WaxOFF & WaxON as I just watched the Karate Kid the other day.

So normally I have this monster Macro which my buddy helped me build years ago & I noticed when I run it some of my labels built in Excel other tabs would get effected.
So the Work around was to rename out the formulas & run that other Macro & everything was fine and I renamed back into being active my formulas.

so all of that is still great. But since I started using the =@FILTER after I comment it out with WaxOFF to /= then I run my other Macro & come back to the
@Filter & run my WaxON to get it back to =@FILTER. The @Filter is not working and I get this result:

 

[Fluff]

If the macro is causing the problem, it would help if you post the code.

 

[RudeBoy]

If the macro is causing the problem, it would help if you post the code.

hmm I have used this code for 23 years and it is like : "A FEW GOOD MEN" "Santiago Must not be Touched"

Is there a way to capture it without having it add things into it?

I noticed when I was looking at another Macro is was adding D:/ comments into it so am worried as DO NOT WANT TO RUIN THE ORIGINAL Macro that have been using for
21+ years = Please advise

 

[Fluff]

I cannot really advise without seeing the code.

 

[RudeBoy]

I cannot really advise without seeing the code.

Let me try to fix this without touching the Master code but if I fail I will be back thanks so much