Upfront disclaimer! I have no programming skills! But can follow clear instructions...
Using Notepad++, I would like to copy a file called "Example1" containing fresh data gathered over the previous week, from one folder, and paste it to another folder that already contains a file called "Example1", which contains historical data for many previous weeks.
Is it possible for the new file to be pasted into the new folder and the data it contains to be added to the current data, instead of just overwriting it and erasing the historical data in the current file?
I would like the new data to make new lines/rows BELOW the existing data. There may also be duplicate lines rows, is there a way to take care of this as well, or would that need to be done separately?
The end goal is to have seamless chronological data with no duplicates in .csv format, simply by copying and pasting once.. I really hope it's possible, it will save so much time!!