Level 3Shaping ArraysPractice, 3 min
VSTACK two teams into one leaderboard
The task
East and West keep separate lists. In G2, stack them into one list with
VSTACK, then SORT it by Leads, most first.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | East rep | Leads | West rep | Leads | Rep | Leads | ||
| 2 | Ada | 34 | Dev | 22 | ||||
| 3 | Bram | 27 | Esme | 38 | ||||
| 4 | Cleo | 41 | Finn | 19 | ||||
| 5 | Gus | 30 |