24FreelanceFreelance marketplace that never sleeps
Response period is over

Power Query

575 views 0 responses#33408
BudgetNegotiable
FormatOne-time projectno prepayment
PaymentBank transfer
Responses acceptedResponse period is overuntil 09.07.2021
Responses0category average: 0.3
Views57513 in 14 days

Project description

Translated
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!
Software development Bank transfer

SafeDeal Escrow Protection

Payora SafeDeal Astrina Shield Verified

Funds are locked in Payora USDT (TRC-20) escrow and released to the freelancer only after delivery approval.

24
Twenty · tip

How to write a response that gets picked

  • Open with the client’s task, not with a story about yourself.
  • Link one or two similar works from your portfolio.
  • Name a price and a deadline — and what exactly they include.
  • Ask one clarifying question: it starts the conversation.

Responses 0

Response texts are visible only to the client.

Same category

Similar projects

All projects in the category
Warehouse inventory app with barcode scanner

Warehouse inventory app with barcode scanner

Looking for a developer to build a mobile warehouse inventory app with barcode scanning, receiving, dispatch, stocktake and reports.

Software development24.09.20260236
0responses
Website accessibility audit against WCAG

Website accessibility audit against WCAG

We need an independent WCAG accessibility audit of our website: keyboard, contrast, screen readers and a clear report with fixes.

Software development24.09.20260236
0responses
Good to know
How do I respond to this project?

Log in as a freelancer, describe how you will solve the task, name your price and deadline. The client reads responses and starts a dialogue with the best ones.

Who can see my response?

Only the client who posted the project and you. Other freelancers do not see your text or price.

Where can I find similar work?

New projects in “Software development” appear every day. All projects in the category

What this page answers