Can I use Table Transformer to transpose each table before using Table Excerpt Include?

Pei-ju Hsu

I saw a way to use Table Transformer to transpose the table after using Table Excerpt Include in this discussion: https://community.atlassian.com/t5/Confluence-questions/Select-table-rows-in-other-page/qaq-p/1759006

Is there a way to do the opposite, i.e., transpose each table first then use Table Excerpt Include? Thank you.

For example, the 2 tables in Table Excerpt are:

A | x1              A | x2

B | y1              B | y2

C | z1              C | z2

And I'd like to have the result looks like

A  |  B  |  C

x1 | y1 | z1

x2 | y2 | z2

It seems the Table Excerpt Include doesn't support merging table by first column but only by first row. If it can support merging table by first column, that can be the solution as well.

Katerina Kovriga {Stiltsoft}

Hi @Pei-ju Hsu ,

You may implement the following steps:

Here we have your tables that are collected with the help of the Table Excerpt Include macro:

The last step is to merge your transposed tables via the Table Transformer macro.

Here we choose the standard Merge preset:

And here check the Transpose source tables option:

And here is your result:

Hope this helps your case.