| Column A | Column B | Column C | Column D |
| --- | --- | --- | --- |
| John | 22 | David | 87 |
| Marcy | 42 | Kumar | 23 |
| Kumar | 35 | Marcy | 42 |
| David | 21 | John | 33 |

In excel ordering Column C according Column A, the data of column C e D are to move together.

Ex: First row will be

| Column A | Column B | Column C | Column D |
| --- | --- | --- | --- |
| John | 22 | John | 33 |

I've tried excel functions like:

`PROCV`, `VLOOKUP` and the sort and filter button in excel with no luck.