Removing Blanks (Array Formulas)

[ntlknight]

Hi there, I've been having a hard time successfully applying array formulas (that I've found online) to remove blanks. 5 of these formulas I found from bettersolutions and only 1 worked for me. I tried several other similar formulas from other sources, but none work quite as needed. In the Excel Sheet I'm attaching I've posted the 4 main formulas which seem like they should be working...but only one of them does work...and it's a formula that posts a #NUM! error in the empty cells below once the formula has run its course. So to get around this I created a "dummy" column of cells with the original formula, that prints all the correct info (including the #NUM!) and then point to those cells in a "final" column, the one I want to look at...using the IFERROR command to not display cells that have #NUM! in them. I believe the Sheet I'm attaching explains this more clearly. While I do now have a working version of what I need (using the 2nd set of "dummy" columns that makes the sheet bigger than it needs to be), after spending 4 hours last night trying to get the other formulas that don't print errors to work, I feel I should see this through properly till the end and understand what's happening a little better. Thank you so much for your time, I appreciate it!