Working with goggle sheets. Transfer similar data from one table

Data Parsing — incorrectly specified categories?

16 USD

Project translated automatically. Log in or register, to view the original There are two tables, in the first table the names of the active substances are stored in different languages, in the table 2 the names of the active substances and the commercial names of the medicines only in Portuguese.You need to take the value from table 1, column D, and find the similar name in table 2, column A (one value from table 1 will include several values from table 2, since table 2 indicates different forms of medications with one active substance) Furthermore, you need to move all the lines with the same name of the active substance, starting from column B, to the active substance in Table 1.The explanation is difficult, so I add tables and scheme how it should look.Table 1 - One document link: https://docs.google.com/spreadsheets/d/1-ing5lqSzG5Af5IWBFFF0SUoE1QWO4Q7RfxHk02V2XE/edit?usp=sharing Table 2 - activities -in + trading port link: https://docs.google.com/spreadsheets/d/1wnkdJcVbWpNDk51e6cgH6dI-RBV7iu9d/edit?usp=sharing&ouid=106080184631693059840&rtpof=true&sd=true It is important to start right now.

Proposals 5 Discussions 3

Please select

Oksana B.

33 1

Projects 35
Rating -
Rating 1 158

Budget: 900 UAH Deadline: 7 days

Good Morning, Diane

I am pleased to accomplish your project.)
I suggest a detailed manual transfer of the taxes from one table to another.
Attention to the details, monotonous work. Chemistry of Zha education (the understanding of the names of active substances).

The deadlines indicate maximum) I will enter into compliance immediately after the terms are agreed.

Good day ! )

Mykola Dudych

37 0

Budget: 500 UAH Deadline: 2 days

Hello to you.
There is experience writing macros for Google Sheets.
Let’s discuss the details.

Gennady P.

Winning proposal

6 0

Projects 6
Rating -
Rating 174

Budget: 700 UAH Deadline: 1 day

Good day . It is ready to create a program that can be used afterwards. I can start right now.

Marina Gaponenko

5 0

Projects 5
Rating -
Rating 315

Budget: 2500 UAH Deadline: 2 days

Hello to you. I will perform the project qualityly according to all your requirements. I have experience with such work.
Write all and we will discuss all details.
I will be happy to cooperate.

Olena B.

99 3

Projects 94
Rating -
Rating 1 510

Budget: 500 UAH Deadline: 1 day

Hello to you. Ready to start work. I will be happy to cooperate! What is the number of lines and budget?

Diana Lee
Yerevan, Armenia
Wale consulting

Projects 1
Rating -
Rating 186