Question
You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2.
Sheet1 contains the following table named Table1.
| Products |
|---|
| abc |
| def |
| ghi |
| jkl |
| mno |
Sheet2 contains the following table named Table2.
| Products |
|---|
| abc |
| xyz |
| tuv |
| mno |
| pqr |
| stu |
You need to use Power Query Editor to combine the products from Table1 and Table2 into the following table that has one column containing no duplicate values.
| Products |
|---|
| abc |
| xyz |
| tuv |
| mno |
| pqr |
| stu |
| def |
| ghi |
| jkl |
Which three actions should you perform in sequence?
Explanation
First import both tables from the Excel workbook so they are available as queries. Then append Table2 to Table1, which stacks the rows of both tables into the single Products column. Finally, remove duplicates on the appended Table1 so values that appear in both tables, such as abc and mno, appear only once. A merge would join the tables side by side instead of stacking rows, and there are no errors to remove.
