CODEWITHSUNDEEP
sortinggoogle-sheetsgoogle-sheets-formulaarray-formulasgs-vlookup
hardy
hardy

Reputation: 557

How to arrange data by matching values from other cell

I have a sheet with data wherein one cell data is in arranged but in another column not so I want to arrange data in 3rd column based on 1st column like bellow

Here is my data Column A has arranged data, Column B is unarranged data.

enter image description here

Now I want to arrange data in Column C and In Column D, Column C copy column A and Column D copy Data From Column B but Paste as it is in Column A.

enter image description here

Update --

 A              | B 
----------------------------------------- 
1st Name        | 3rd Name 
_________________________ 
2nd Name        | 1st Name 
_______________________ 
3rd Name        | 2nd Name

want to arrange data in column B as data in Column A

 A              | B 
----------------------------------------- 
1st Name        | 1st Name 
_________________________ 
2nd Name        | 2nd Name
_______________________ 
3rd Name        | 3rd Name

Want data like this.

Upvotes: 1

Views: 85

Answers (1)

player0
player0

Reputation: 1

to sort by each column priority-wise:

=SORT(A:D, 1, 1, 2, 0, 3, 1, 4, 1)

to sort C column based on A column:

=ARRAYFORMULA(IFNA(VLOOKUP(A:A, C:D, {1, 2}, 0)))

to sort each column independently:

={SORT(A:A), SORT(B:B, 1, 0), SORT(C:C), SORT(D:D)}

Upvotes: 1

Related Questions