Using the Power Query Editor to join rows and columns. NPA (5/6) PDA (7/8)
Download Advanced Practice Combining Datasets in Excel
Joining datasets when the key columns have different names, there are multiple key columns and selecting an appropriate join type. NPA (5/6) PDA (7/8)
Appending rows and joining columns to a dataset. NPA (5/6) PDA (7/8)
| NPA 4 | NPA 5 | NPA 6 | PDA 7 | PDA 8 |
| ✔️ | ✔️ | ✔️ | ✔️ |