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)
How do I do this? I'm trying all sorts of sorting but nothing worked so far.