Forum Discussion
How to automatically expand table 2 with data from table 1?
I load a csv file to excel, which becomes table 1, in a sheet. On another sheet i have table 2 that aggregates values of certain columns of table 1, using formulas. When table 1 is loaded with new ...
Hi ricardo121 (Happy New Year too)
Re. the sorting issue. Depending on what your fomulas do and which cells/columns/rows they reference, it is possible that Excel revert the Sorting to ensure your formulas still work (I don't have a good example with me right now)
Get & Transform can do the sorting of the values on a separate sheet - no more need to copy/paste, just a refresh of the query once it is in place
