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 like blank cells. Is something like this possible without manually creating blank columns so both sheets have the same headers?
Ex:
Table 1:
| Name | Demo Data 1 | Demo Data 2 |
| Paul | Address 1 | Phone 1 |
| John | Address 2 | Phone 2 |
| Sarah | Address 3 | Phone 3 |
Table 2:
| Name | Demo Data 1 | Demo Data 3 | Demo Data 4 |
Jacob | Address 4 | Zip 4 | State 4 |
| Yessenia | Address 5 | Zip 5 | State 5 |
| Larry | Address 6 | Zip 6 | State 6 |
Desired result:
| Name | Demo Data 1 | Demo Data 2 | Demo Data 3 | Demo Data 4 |
| Paul | Address 1 | Phone 1 | ||
| John | Address 2 | Phone 2 | ||
| Sarah | Address 3 | Phone 3 | ||
Jacob | Address 4 | Zip 4 | State 4 | |
| Yessenia | Address 5 | Zip 5 | State 5 | |
| Larry | Address 6 | Zip 6 | State 6 |
- 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
2 Replies
- 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 -> Appendwhy to add to the data model?
