SOLVED

Build a dynamic list with VSTACK based on the table list.

Steel Contributor

Build a dynamic list with VSTACK based on the table list.

Hi,

I might be pushing it now. But it is maybe a solution for this.

The goal is to make VSTACK dynamic, build a table based on the table names in the workbook.

The green table is a named list of the tables in the workbook. (Made with power query).

Using indirect and any other function is it possible to build one formula using VSTACK? Make the "non dymanic function" dynamic?

Best regards

- Geir

2 Replies
best response confirmed by HansVogelaar (MVP)
Solution

Re: Build a dynamic list with VSTACK based on the table list.

``=REDUCE({"Name","City","Rng"},SEQUENCE(ROWS(Tabelle5[Table])),LAMBDA(x,y,VSTACK(x,INDIRECT(INDEX(Tabelle5[Table],y,1)))))``

You can try this LAMBDA function. The names of the three tables on the left in the example are Tabelle2, Tabelle3 and Tabelle4. The name of the small blue table which references the table names is Tabelle5.

Re: Build a dynamic list with VSTACK based on the table list.

Great, it worked perfect. Thank you.
1 best response

Accepted Solutions
best response confirmed by HansVogelaar (MVP)
Solution

Re: Build a dynamic list with VSTACK based on the table list.

``=REDUCE({"Name","City","Rng"},SEQUENCE(ROWS(Tabelle5[Table])),LAMBDA(x,y,VSTACK(x,INDIRECT(INDEX(Tabelle5[Table],y,1)))))``

You can try this LAMBDA function. The names of the three tables on the left in the example are Tabelle2, Tabelle3 and Tabelle4. The name of the small blue table which references the table names is Tabelle5.