Problem with setting up dynamic ranges skipping blanks

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

Instead of the volatile OFFSET function make each of your ranges a Table
Select B1:B14 - Insert - Table
Change the name to whatever is needed. This " table" will expand automatically when rows are added
The same for the other columns
The Tables and their names are to be found in the Name manager

the data I posted is a simplified version - range (2:26) for each column actually contain array formulas. the blanks are not real blanks but "" being returned from the array formula. the purpose of setting it up this way is so that the user doesn't have to manually update the data. not sure how to achieve this by using tables? the setup are exactly the same for the offset formula, I'm scratching my head why only the ChartYrs works ...