I am looking to add data from four excel files to a single empty file(Lets call it Results.xlsx). After copying the data from the first file to Results.xlsx, would it be possible to add the second file’s data to the bottom of the list on Results.xlsx? And so on with the next few files.
I was able to copy the data from the four files onto Results.xlsx but only onto a certain range.
Is there a simple way to remove empty rows between the sets of data in this file?
This happens in cases where some empty cells are edited (and made empty again) after the last used row, excel shows the last used as row as the one which was made blank.
I dont see any straight forward activity for this. One option is read the result.xlsx sheet using read range and delete duplicate rows in datatable. (in case any of your other rows dont have duplicate data).
If not, best way I would do is using excel shortcuts. Let me know if you need help there!