Table Transformer is one of the macros bundled in the Table Filter, Charts & Spreadsheets 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. Wrap tables or table macros with Table Transformer in the edit mode: