Forum Discussion
Solved
Combine Multiple Excel Sheets with Different Columns
Hi all, I am attempting to combine multiple excel sheets into one sheet where some column headers match, and some are different. If sheet1 does not have the same header as sheet2, then I would li...
- Seems I found the answer myself with some more playing around! Thank you to anyone currently typing an answer. For anyone who needs this in the future:
1. Load both sheets as as data connections and add to the data model.
2. Then click Get Data in the data tab and select Combine Queries -> Append
Seems I found the answer myself with some more playing around! Thank you to anyone currently typing an answer. For anyone who needs this in the future:
1. Load both sheets as as data connections and add to the data model.
2. Then click Get Data in the data tab and select Combine Queries -> Append
1. Load both sheets as as data connections and add to the data model.
2. Then click Get Data in the data tab and select Combine Queries -> Append
why to add to the data model?
