ikos | Static analyzer for C/C++ based on the theory of Abstract Interpretation | Code Analyzer library

I am a bit struggling with a way to variably adding lines to table according to capex category, partner number and period.

Mu final table looks like (more sections, but for example), it is not a listobject item:

my source looks like (more pivot tables, but for example):

I am indexing data from source to final table. But when combination do not exist, like the orange field in data source, in final table it should be Capex O - 3to5 years, and partner 1115, I don't know how to add it.

I thought of find function in case I would create unique ID for every line (combination of Capex letter, position (period ID) and partner), but in this case I am a bit stuck with different treatment of periods in final table and source. In final table 1-2 years and 2-3 years are combined as well as 3-4 years and 4-5 years. And I don't think transposing the source will be useful (you can prove me wrong).

Also I would need add lines in final table only for situations where value is <> 0.

I would need to add the new row in A-Z order for every capex category and period (except if its 999999, which should always be in first position; and 999999 is default value, so it is already in every capex category and period)

Every green column has its own calculated workbook where source is listed on separate sheet (Pivot)

Hope I described it clear, in any doubts, please let me know.

EDIT 18 Mar 22:

So, I almost figured it out, except couple issues.

First I created support columns in pivot sheet using concatenate on partner ID and position (there is such concat in original table, not presented before)

My code (wsSUM is declared in Public section of the code, as it is used accross modules; also you don't see whole code, only part regarding this issue):