Merge data from multiple workbooks to a single spreadsheet in excel using power query 

Most often, researchers struggled to combine data from many sources in various workbooks into a single spreadsheet that could be utilised for bibliometrics and systematic literature reviews. In this video, I have outlined a straightforward technique for combining multiple workbooks into a single spreadsheet for bibliometrics and systematic review using the power Query option in Microsoft Excel.