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

1

1 Answer 1

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

2
  • Please check the updated answer (following my initial hasty reply) Feb 20, 2020 at 0:51
  • Have you ever tried this answer? Feb 28, 2021 at 5:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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