Hello guys can you guys possibly help me sort a range/table(open to whichever is easier)
I would like to sort to it to look like this
Essentially matching the name on Column B with the similar name in column C and sort while keeping columns C and D aligned
Book1 | |||||
---|---|---|---|---|---|
B | C | D | |||
1 | Names | Description | ID | ||
2 | John Cena | You Can't See Me- John Cena | 5 | ||
3 | The Undertaker | Time to Play The Game- Triple H | 6 | ||
4 | Funaki | Heartbreak Kid- Shawn Michaels | 8 | ||
5 | Rico | Can you Smell- The Rdock | 7 | ||
6 | Eugene | I don't Know-Eugene | 4 | ||
7 | Triple H | SmackDown's number one Announcer- Funaki | 2 | ||
8 | The Rock | Rest in Peace- The Undertaker | 3 | ||
9 | Shawn Michaels | Kiss me- Rico | 1 | ||
10 | That's the Bottom Line- Stone Cold | 9 | |||
11 | Here Comes the Pain- Brock Lesnar | 10 | |||
Sheet1 |
I would like to sort to it to look like this
Book1 | |||||
---|---|---|---|---|---|
B | C | D | |||
15 | Names | Description | ID | ||
16 | John Cena | You Can't See Me- John Cena | 5 | ||
17 | Funaki | SmackDown's number one Announcer- Funaki | 2 | ||
18 | The Rock | Can you Smell- The Rdock | 7 | ||
19 | |||||
20 | |||||
Sheet1 |
Essentially matching the name on Column B with the similar name in column C and sort while keeping columns C and D aligned