Table transformer to create column per value

[Aurélien Thazet]

Hello, 

I've got several pages with the same table format:

I would like to consolidate all this information in the same table by using Type of evaluation values as columns and each page as a row. Here is the final result I'm looking for.

Is there a way to do this with Table Transformer?

Many thanks,

Aurélien

[Stiltsoft support]

Hi @Aurélien Thazet ,

As I see, there can be a different number of the "Type of evaluation" for each page: A, B for Page 1 and A, B, C for Page 2.

So, I can suggest using the following workaround: collect your original tables to the master page using the Table Excerpt/Table Excerpt Include macros. Tick the "Show as a report" option and select to show page title in the meta data field.

Then wrap your Table Excerpt Include macro in the Pivot Table macro (as I see it, you'll get smth like this):

Now you need to configure your Pivot Table macro:

Hope it helps your case.

[Stiltsoft support]

Hi @Janice ,

As we see, our custom tags were added to the system - thank you so much! We always add them to the related questions.

Please one more issue from our side: last week we officially renamed our app from "Table Filter and Charts for Confluence" to "Table Filter, Charts & Spreadsheets for Confluence".

Please can you update one of our tags as well: table-filter-and-charts -> table-filter-charts-spreadsheets?

Other tags are good as they are.

Thank you!