field merge with How To Merge Two Excel Spreadsheets With A Common Field 04 Mar, 2021 Click on the Data tab and then click on Consolidate. Now select the 2nd range along with Header row and then again cli…