Dynamically generate columns from rows on other table... dynamically regenerate schema?

[generativegeorg]

I need to make a training matrix like this screenshot from excel

1. The columns represent different documents, a list of these documents is kept on another table.

2. When a new document is added to the doc table, a new row needs to show up here.

Is my only solution to do like a pivot table in sheets and just make a link to sheets instead of an AppSheets view?

I was doing this with a people table, a docs table, and a training log / lookup table with some vba macros before.

[Marc_Dillon]

Appsheet cannot do pivot tables, nor can it programmatically regenerate a table's structure.