To vote on the idea, please sign in with your personal or social account (Google).
To watch the idea, please sign in with your personal or social account (Google).
I use Table Transformer for the tables with rich contents in the cells the the row spans and often need to merge such tables into one large sheet.
The problem is when I have to merge some rich content cells in a single cell it renders as a plain text loosing all the original formatting (I use SUM and ARRAY here) and ESCAPESYNTAX is no help here, unfortunately.
The only solution I know is using Pivot table with LITERAL aggregation which works fine but does not allow to override the column header.
I wonder if it is possible to add LITERAL aggregate to the Table Transformer itself.