Combine data with Power Query
Combine data table(sheet) with Power Query.
In this video, you can combine Data 1 and 2 together using Power Query editor. If you want to follow a long, download sample file here: http://akademipowerpoint.com/append.xlsx