1

My mobile teams rely on a spreadsheet for localization. With time I realized that each team are using their own keys rather than using the same one. I need to start from scratch and have both teams use the same key. How can I copy over all the rows that have matching keys into another sheet as depicted here?

enter image description here

so for example in the new sheet I would like to see something like this

identifier       | english             | arabic               | 
-----------------+---------------------+----------------------+
credit_card      |credit card          | بطاقة الائتمان        |
cash_on_delivery |cash on delivery     | الدفع نقدا عن الاستلام |
..

so notice the row where identifier iOS has cash will be ignored because the corresponding key in android label_cash doesn't match it

  • Please add a brief description of your search/research efforts as is suggested in How to Ask, specify if you are looking for a formula or script and add a link to a demo spreadsheet (you might find helpful this [ How to share a Google Sheets demo spreadsheet](webapps.stackexchange.com/q/138382/88163)) – Rubén Feb 19 at 16:06
1

If your data sheet is in Sheet1 you can use the FILTER function in your other sheet.

=FILTER({Sheet1!A2:B,Sheet1!D2:D},Sheet1!A2:A=Sheet1!B2:B)

Have a look how the FILTER function works

| improve this answer | |
  • Please check the updated answer (following my initial hasty reply) – marikamitsos Feb 20 at 0:51
  • Have you tried this solution? Did it work for you? If not we should try finding out why. If yes, as per site guidelines when an answer addresses your question, you should accept it and even upvote it so others can benefit as well. – marikamitsos Feb 20 at 18:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.