Table Transformer is one of the macros bundled in the (OUTDATED) 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. You can also get any table transformation such as:
Using complex formulas
Using If / Then logic
Applying advanced filtration and more.
The Table Transformer macro is available in Confluence Server only.