Forum Discussion
Sotar_Rua
Sep 12, 2023Copper Contributor
Can't merge spreadsheets
I need to consolidate two spreadsheets. They were created with different formatting - column names, number of columns, etc. I tried following instructions from https://support.microsoft.com/en-us/office/combine-data-from-multiple-sheets-dd7c7a2a-4648-4dbe-9a11-eedeba1546b4, but I couldn't get it to work. I then created a new sheet and pasting both into it, but that didn't work. My goal is to view all rows so I can see duplicate entries. Please advise. Thank you.
1 Reply
Sort By
- JKPieterseSilver ContributorIt will help if you make sure the two have matching column names. Otherwise Excel may not know how to combine the columns.