Forum Discussion
Hogstad_Raadgivning
Jul 15, 2023Steel 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
=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.
2 Replies
Sort By
- OliverScheurichGold Contributor
=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.
- Hogstad_RaadgivningSteel ContributorGreat, it worked perfect. Thank you.