There are two .xls files one containing data about activities done with clients, and the other contains information about financials. The accountant charges the head corporation. The other details are done with subcompanies so they all have different names. I need a way to take company x and y and be the same company z when it comes to billing. I'm totally lost in this regard.
Pls don't tell me to standardize my data. In about six months to a year there is plan to go with a DB that I will eventually have to build.