Forum Discussion
Betsy2125
Dec 03, 2018Copper Contributor
Combine spreadsheets into one
I have this code in Google Sheets which combines several spreadsheets, in the same workbook, into one master sheet.
=QUERY({Sheet1!A2:C;Sheet2!A2:C;Sheet3!A2:C;Sheet4!A2:C;Sheet5!A2:C;Sheet6!A2:C;Sheet7!A2:C;Sheet8!A2:C},"where Col1 is not null")
All spreadsheets have the same type of information, but from different sources. We have moved to MSoffice and I can't seem to find an easy way to do this in Excel. Please help.
- JKPieterseSilver ContributorPowerQuery is what you are looking for: https://www.excelguru.ca/blog/2014/11/19/combine-multiple-worksheets-using-power-query/