Forum Discussion
Appending data using power query
how to append data of a specific sheet of a workbook to worksheet of another workbook using power query such that the existing data in the sheet not deleted? i am using office 365 latest version and ...
You can use PowerQuery within a single workbook if you want to. Add a new worksheet then use the Data Tab and click PowerQuery. Use the Excel connector and choose the file that you currently have open.