If your data is truly dynamic—meaning you don't know if there will be 3 rows or 30—and a "flat" structure isn't feasible, the Page Properties macro may be the wrong tool for the job.
In Confluence, the Page Properties Report macro is designed to display exactly one row per source page confluence page properties report multiple rows
18;write_to_target_document1b;_ciPuabL2OOfP2roP5bu40A0_100;6; If your data is truly dynamic—meaning you don't
3 rows in the report.