How to combine two tables with no data in common, then edit combined table.

[Moya Alhayek]

I'd like to be able to combine two tables like below 

a	b	c
a	b	c

x	y	z
x	y	z

To create 

a	b	c	x	y	z
a	b	c	x	y	z

But then be able to further edit the combined table (to add comments and such).

[Katerina Rudkovskaya [Stiltsoft]]

Hi @Moya Alhayek,

@Fabio Racobaldo _Herzum_ has kindly mentioned our Table Filter and Charts for Confluence app regarding your case, so let me clarify some points.

If we are talking about native Confluence tables, the Table Excerpt/Table Excerpt Include macros can collect multiple-row tables with similar headers into one big report. The same can be done with the help of the Table Transformer macro and its standard “Merge” preset. As I see from the screenshots, your headers are different, so that is not the case.

To join tables as you’ve shown us on the screenshot, you may use the Table Transformer macro and its “Lookup” preset. But your tables (and the third one with comments that you want to add later) should have a key column with unique fields (the simplest one is a ROWNUM() function). You can’t join tables without any keys: rows coming from different tables should be somehow matched.

If you just want to combine the two tables manually and then add comments wherever you need like you can do, for example, in Excel, I can suggest our Table Spreadsheet macro. You’ll be able to store your tables on different sheets, reuse these tables using cell formulas on another sheet and type in more additional info as well.

[Fabio Racobaldo _Herzum_]

Hi @Moya Alhayek and welcome,

unfortunately you can't do that using builtin feature. You could try some external app like https://docs.stiltsoft.com/tfac/cloud/how-to-use-table-excerpt-and-table-excerpt-include-macros-42241623.html?utm_source=atl_community

Fabio