Question: You have two Excel spreadsheets with data from separate reporting units. Both spreadsheets have the same column names. What Power Query Editor feature can you use to create a unified dataset?
- Unify
- Append
- Merge
- Group
Answer: The correct answer of the above question is Option B:Append