Working with the client base (connect information) Excel

Databases & SQL, Text Editing & Proofreading — incorrectly specified categories?

Project translated automatically. Log in or register, to view the original I greet everyone. You need a person who works well with Excel. Task: There is a base from shipping companies as an indicator. There are also 8 files and one base with CRM bitrix, where these companies are distributed with different data. For example: In one file you can draw the INN of the company, and in the other the phone number of the manager of the same company, as well as in the bitrix there are all these companies with dispersed information and many duplicates. The task is to unite all the information to each company. Fields to be filled: 1 . Type of company - Everywhere type of "corporate companies" 2nd Area of Activity Three Name of the company 4 . Registration number and 5. INN 6 . The Col. The courts 7 . The Leader 8 . The Doll. The Leader The 9. Number of The 10. Email 11 of 11. There will be a couple of additional fields. The information is not dispersed chaoticly, it is structured according to the table in each column. The only nuance is that this information is in different tables differently.

Proposals 1

Roman Kotik

19 2

Projects 19
Rating -
Rating 591

Budget: 500 UAH Deadline: 1 day

Good day, I already see how it can be quickly and easily organized.Therefore, we are free to combine your data into one table. He worked a lot with Excel even wrote macros to work with them. I look forward to the response to the request.

Aleksandr Pigolenko
Kyiv, Ukraine
Guru IT

Projects 10
Rating -
Rating 446