Close two databases in excel
1 . Applications
2nd orders
All orders are the same in the applications. There are two different columns in the base, except the name and order (if there is).
It is necessary for a formula or to propose a quick action algorithm to close two bases horizontally:
All orders must be in the same line as their request (find by phone number or order number). Where there is no order, leave an empty place.
If the application has two or more orders, then separate lines to enter with a full set of data from the application.
It is impossible to do it manually, as the line is a couple of tens of thousands.
Data sampling on request
Client's review of cooperation with Mihail Bychkov
Close two databases in excelA great executive. Excellent communication and quality work
Freelancer's review of cooperation with Yevgeny Boru
Close two databases in excelI liked working with Eugene, I recommend collaboration!
-
345 22 0 Hello to you. Ready to perform the task. I will be happy to cooperate. turn to
-
1134 38 0 Good day, I can solve this in Excele using its special Power Query extension I know it at an advanced level. The request will only be updated in the future if necessary.
-
308 2 0 Good day Eugene!
I can solve these problems with Python. The script will form a new file and the previous will leave unchanged. You need a full list of fields of application and order.
-
117 1 0 Hello to you. I have a lot of experience working with data in Excel. For more detailed information, as well as to determine the exact deadlines and costs of the work, please leave me an example.
-
636 35 0 Good day I can offer you a table fusion with MS Acess. I do it within a couple of hours. If necessary, I will explain how to do it later.
-
368 5 0 The task is understandable. I do today.
Contact Personal Messages
-
988 30 0 Good day ,
Ready to fulfill your task.
To understand this, we need an example of files.
Give an example to LS.
-
2141 85 0 Готов сделать.
ооооооооооооооооооооооооооооооооооооооооооооооооо
-
Пришлите сэмпл
-
Current freelance projects in the category Databases & SQL
Power BI
16 USD
The dashboard runs on a Google server, we need to transfer all logic + code Required skills: deployment of ETL processes on a Linux server + working with BigQuery and Postgre There is working code that runs on Google, where the database itself is, we need to transfer it to… Python, Databases & SQL ∙ 1 day 23 hours back ∙ 15 proposals |
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 3 days 23 hours back ∙ 11 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 4 days 10 hours back ∙ 5 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 7 days 17 hours back ∙ 16 proposals |
Accounting, planning, and sales system for a mushroom farm
603 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 9 days 21 hours back ∙ 61 proposals |