1
Александр
no recommendations
no complaints
Project title: Power Query
Type of cooperation: One-time project
Section: Software development
Prepayment: without prepayment
Payment methods: Bank transfer
Acceptance of requests: from 2021-07-04 until 2021-07-09
Type of cooperation: One-time project
Section: Software development
Prepayment: without prepayment
Payment methods: Bank transfer
Acceptance of requests: from 2021-07-04 until 2021-07-09
Project description:
Good afternoon!
Programmer services are required. You need a ready-made exel file not lower than 2016. (I have 365 updates) with a ready-made request in power qwery, which makes a mass replacement in the column of the source table by referring to a separate table consisting of two columns: was, became.
Accordingly, if the text of the column cell of the source table contains a text that coincides with the text in any of the column cells of the second table, then this text is replaced by text from the corresponding column cell of the "became" of the second table.
Important! Here, apparently, you need a formula, because the essence is to replace the PART of text in the cell of the column of the original table.
For example:
1. In the source table, we have written in the cells sentences about fruits, such as:
This is a delicious apple, eat it.
2. In the second table we have written in the column "was" fruits (including an apple), and on the right in the column "stolen" recorded vegetables (to the right of the apple written tomato).
3. After the request is fulfilled, it should be:
This is a delicious tomato, eat it.
And so for every cell.
Is the question clear?
In theory, it should be quite trivial. But I found only one normal formula on the Internet and didn’t understand anything about it.
Can you do it fast?
I can pay you extra for the urgency.
Thank you!
Good afternoon!
Programmer services are required. You need a ready-made exel file not lower than 2016. (I have 365 updates) with a ready-made request in power qwery, which makes a mass replacement in the column of the source table by referring to a separate table consisting of two columns: was, became.
Accordingly, if the text of the column cell of the source table contains a text that coincides with the text in any of the column cells of the second table, then this text is replaced by text from the corresponding column cell of the "became" of the second table.
Important! Here, apparently, you need a formula, because the essence is to replace the PART of text in the cell of the column of the original table.
For example:
1. In the source table, we have written in the cells sentences about fruits, such as:
This is a delicious apple, eat it.
2. In the second table we have written in the column "was" fruits (including an apple), and on the right in the column "stolen" recorded vegetables (to the right of the apple written tomato).
3. After the request is fulfilled, it should be:
This is a delicious tomato, eat it.
And so for every cell.
Is the question clear?
In theory, it should be quite trivial. But I found only one normal formula on the Internet and didn’t understand anything about it.
Can you do it fast?
I can pay you extra for the urgency.
Thank you!
