Repeating Rows based on Property IDs and GL Codes

Hello all,

This is a difficult question for me to phrase, but I can provide background:

I have 200 properties.

I have a Statement of Cash Flows with each property listed with hundreds of GL Codes and amounts.

I want to summarize the data in a new table by taking whatever GL Codes I want from every property and their respective amounts.

I want the table to autopopulate, repeating x number of properties, with x being the count of GL Codes being asked for (in the array).
- If there are 8 values in an array, I would like each property ID to repeat 8 times, with one of the values in the array next to each.

Please see attached tables for reference and explanations:
Problem.xlsm