Forum Discussion

Hogstad_Raadgivning's avatar
Hogstad_Raadgivning
Steel Contributor
Jul 14, 2023

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...
  • mtarler's avatar
    Jul 14, 2023

    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"))

Resources