0

I have 3 columns in Google Sheet. Column A have 95 rows with value. Column B and C have 500 rows with value: enter image description here

I need to sort Column B to match with Column A. Column C represent value associated with column B. So After sorting expected result should be like below pic (i only did for first 3 row but actually Column A and Column B will be identical for all of Column A's value - 95 rows)

enter image description here

How do I do this? I'm trying all sorts of sorting but nothing worked so far.

  • 1
    Thank you Sir @Serenesat for Update, – Eklavya Sep 17 '19 at 20:27
0

Assuming that Column A and Column B have unique values:

  1. Filter Column B to match the elements of Column A
  2. Sort Column A and Column B using the same criteria

 

Built-in Google Sheets functions that could help you:

  • Use FILTER or QUERY to filter values
  • User SORT or QUERY to sort values

Another alternative is to use Google Apps Script, for details checkout https://developers.google.com/apps-script/guides/sheets

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.