Forum Discussion
Add the table name to a column using VSTACK.
Hogstad_Raadgivning I don't know of a way to dynamically grab the Table Name but given a Table Name you can easily ADD that column using EXPAND():
=VSTACK(EXPAND(t_appelsin,,4,"t_appelsin"),EXPAND(t_plommer,,4,"t_plommer"),EXPAND(t_pærer,,4,"t_pærer"))
Hogstad_Raadgivning Inspired by the earlier answers, the attached file contains a dynamic solution that does not require hard-coding of the table names in the EXPAND or VSTACK functions.
Though you need to add two formulas on the sheets that contain the tables you want to stack. In my example I added in A4 a formula like:
=tablename[@Måned]
Hide column A if you don't want to see this formula!
Then in B1 of every sheet I pick-up the table name with:
=MID(FORMULATEXT(A4),2,FIND("[",FORMULATEXT(A4))-2)
Hide row 1 if you don't want to see the table name!
The stacking formula then looks like this:
=VSTACK(EXPAND(t_appelsin,,4,Appelsiner!B1),EXPAND(t_plommer,,4,Plommer!B1),EXPAND(t_pærer,,4,Pærer!B1))
Change the sheet names and/or table names, and all will be updated dynamically. Though you need to press F9 to see the changes.
