I want to consolidate Excel sheets that hold numeric values and text into one single sheet. I tried various methods as posted here, https://www.exceldemy.com/excel-combine-sheets and the text either does not copy at all or is being replaced with null. I am not sure what I am doing wrong, does Excel even allow this? Would I need a 3rd party plugin?
Excel version: 365 MSO (Version 2208 Build 16.0.15601.20072) 64-bit
Data Description: One sheet with name, DOB, scores, ID, plus demographic data such as male, female, (M, F), and ethnicity, (B, H, W). The second sheet holds similar data, but with other information.
Goal: Consolidate data, ideally without duplicating same rows, like DOB; preserve text, like single characters (M, F, S) and words like Campus A, Campus B. I want all data in one sheet including the original headers.
I achieved some success with the method get data, from other source, black Query. BUT, my 400 entry rows are doubled, albeit both sheets hold the same person ID numbers, I simply want to add the extra columns of sheet two to sheet one.
Screenshot of two overlapping different sheets:
goal, consolidated to this:
