Forum Discussion
Excel Consolidation
I am doing data input and I need to consolidate the input from my main table to a different sheet in a new table. I need this consolidation to run continuously and continue to add the information as ...
Hi DK_25
if you work with Excel from Microsoft 365, some of the new dynamic array functions might be a solution.
Depending on the exact requirments this could be one of the FILTER or VSTACK function. Especially if the source/input data is formatted as a table, FILTER or VSTACK would be really dynamic and the output data grows when the input data grows.