Hello,
I have this problem, I've tried to look up the solution but I didn't manage to find anything that would help me to solve it.
I have a big excel sheet with number plates and attributed to them: velocity, times, dates, etc. In the second external source i have csv with another data, now without anything more than number plate & car type. I want to merge this data in the way that i would have information of car type in the excel worksheet with number plates and dates (so essentially merge the second with the first.
It's more than possible that in the second file number plates will be attributed to more than one type of car, as this process was done automatically.
I really cannot wrap my head around this, even how to approach this problem. Files are gigantic, so no way of doing it manually.
I'd really appreciate any help.
Regards,
fea
Bookmarks