I have a source folder with CSV files in an identical format and data structure. The files contain monthly data from our internal system with columns named "service name", "date from", "date to", "monthly trafic". Every files are named as YYYYMM.csv. I inicially imported monthly data from these files as a new query from a folder. This created an Excel table in the same structure as in the CSV files. After that, I created one more column "Customer" and wrote a formula into the first cell in the column under the table header and pushed Enter. It automatically fill in all cells in column in the range of the table with the formula. This works well.
If I insert a new CSV file with new data into the folder and Update all in excel spreadsheet, calculated column named "customer" contains a gap of cells without a formula, while new data is correctly imported into the range of the table. And this is the problem. I don't want to have the gap in the data and I don't want to manually copy the formula into cells in the gap.
Any help appreciated. Thank you very much.