Forum Discussion
Solved
Add the table name to a column using VSTACK.
Hi, When I combine multiple tables in Excel using Vstack, is there an easy way to add the table name to the dynamic list? All tables have the same structure. One workaround is to add a new co...
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"))
You may find your answer in this video
https://youtu.be/EZ93ofFj4kc
https://youtu.be/EZ93ofFj4kc