At this point, your merged data is ready and all you need is to load it into your new workbook.After that, double click on the header and select “Rename” to enter a name for the column i.e.Here in the “Value to Replace” enter the text “.xlsx” and leave “Replace With” blank (here idea is to remove the file extension from the name of the workbook).So, right-click on the column header and select “Replace Values”.At this point, you have merged data from all the files into your power query editor and, if you look closely you can see a new column with the name of the workbooks from which data is extracted. From here, the next thing is to select the table in which you have data in all the workbooks and yes, you’ll get a preview of this at the side of the window.
