User Profile
rjboudreau
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Re: Combine Multiple Excel Sheets with Different Columns
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 -> Append20KViews0likes1CommentCombine 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 6Solved18KViews0likes2Comments
Recent Blog Articles
No content to show