Need a Macro to merge two datasets based on two fields (IP Address and Timestamp).
Entries with same IP and time within 30 Minutes Timeframe should be merged into one line considering certain values. Best would be a Desktop application where one can select two csv Files and the program generates a new file with merged data.
Or excel Macro would be ok. It must be easy to apply on different files which have different names (same data structure).
attached you find examples of the two datafiles.
one set contains userdata, the other contains some data from a survey form.
Columns T to W from suite_export(9) should be merged to the end of first file: suite_export(8).
Budget is 50 €.
Hello, I’m an Excel VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
€50 EUR in 3 days
4.9 (167 reviews)
6.6
6.6
5 freelancers are bidding on average €46 EUR for this job
Dear sir,
Greetings.
I have checked the attached resources and able to complete.
As i need to write codes and test, that why can't show you a sample.
Thank you.
hi there, i will create windows desktop application which will allow you to select two csv files and will merge base don certain conditions, ready to start now and create in few hrs. thanks