Level 3Shaping ArraysPractice, 3 min
CHOOSECOLS: only the columns that matter
The task
The social lead wants three columns from this export: Campaign, Spend and Clicks, in that order, for Paid Social only. In H2, FILTER the rows, then pick the columns with
CHOOSECOLS.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Date | Campaign | Channel | Impressions | Clicks | Spend | Campaign | Spend | Clicks | |
| 2 | Oct 1 | Brand terms | Paid Search | 8,200 | 640 | $1,150 | ||||
| 3 | Oct 1 | Lookalike 1% | Paid Social | 21,400 | 410 | $980 | ||||
| 4 | Oct 1 | Retargeting | Paid Social | 9,800 | 355 | $620 | ||||
| 5 | Oct 1 | Product terms | Paid Search | 12,600 | 520 | $1,430 | ||||
| 6 | Oct 1 | Creator collab | Paid Social | 30,500 | 615 | $1,270 | ||||
| 7 | Oct 1 | Competitor terms | Paid Search | 5,400 | 190 | $760 | ||||
| 8 | Oct 1 | Prospecting video | Paid Social | 44,100 | 290 | $1,540 | ||||
| 9 | Oct 1 | Newsletter | 3,100 | 240 | $0 |