No easy way to do this yet.
Assuming there is a valid reason why you implemented those as two separate tables despite the same schema, and not a single table with two filtered views, here’s what you can do:
-
Make a third “report table” that you’ll populate with a mixture of tasks (create rows) from both sources upon a button click. Con: this risks being included in the Doc History and leaking private data.
-
Use my upcoming Cross-doc Plus pack to create a union table from two sources.
By private page you mean private doc? Otherwise there’s no such thing as private pages. Anyone having read access to the doc can figure out how to see all of the doc, including hidden and filtered items.