18,090 views
Today we will talk about how to merge data from more than one Excel file and more than one sheet into one sheet with all the data. Through this lesson, you can merge all the data into one file or one worksheet so that you have a reference for all the data related to you or your work. The lesson is divided into two methods.. The first method: which is to merge several worksheets into one sheet only. The second method: which is to merge a file containing several Excel files into one sheet only. Also, if any data is updated in any file, the data is updated in the detailed sheet. All of these methods will be through Power Query. The lesson is very useful, especially for those working in the field of human resources. #Hr #Power_Query #Merge_data_in_Excel_Hr