Ok so different letters have different number of items, which are listed in a table. Seeing how field codes don't disappear when in tables, I introduced the following functions into the rows in column A:

{ IF { Mergefield Item1 } = "" "$" "{ Mergefield Item1 }" }
{ IF { Mergefield Item2 } = "" "$" "{ Mergefield Item2 }" }
{ IF { Mergefield Item3 } = "" "$" "{ Mergefield Item3 }" }
...

So when there's no ItemX, $ is introduced and then my MACRO 1 deletes all those empty rows. This is working great.

To use this MACRO 1, I need to click on Finish and Merge first to have all the letters show up. Once all the empty spaces are deleted with this MACRO1, I'd need to save the records as individual PDFs.

In essence, the problem is:
MACRO 1 -> Only works after Finish and Merge
MACRO 2 -> Only works before Finish and Merge

Could these macros be tweaked in some way? Any alternative that isn't too time consuming?

Thanks for your time Paul, bare with me, my knowledge on this is limited