Table Transformer is one of the macros bundled in the Table Filter and Charts for Confluence app. The macro allows you to merge and associate all kinds of tables using both automatic presets and advanced SQL queries.
Add Table Transformer on the page
Step 1. Add the macro to the page in the edit mode: