SOLVED

Consolidating data from multiple worksheets

%3CLINGO-SUB%20id%3D%22lingo-sub-291872%22%20slang%3D%22en-US%22%3EConsolidating%20data%20from%20multiple%20worksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-291872%22%20slang%3D%22en-US%22%3E%3CP%3EEg.%26nbsp%3B%20I%20have%20ten%20worksheets%2C%20all%20have%20same%20columns%3A%20email%20address%2C%20first%20name%2C%20last%20name.%26nbsp%3B%20Each%20worksheet%20has%20100%20rows%20filled.%26nbsp%3B%20I%20want%20to%20combine%20them%20into%20one%20worksheet%20that%20will%20have%20all%20the%20entries%2C%20i.e.%201000%20lines%20of%20data.%26nbsp%3B%20How%20do%20I%20do%20this%3F%26nbsp%3B%26nbsp%3B%20(I%20have%20simplified%20this%20question.%26nbsp%3B%20I%20actually%20have%20more%20columns%20and%20data%2C%20but%20the%20question%20is%20clearer%20this%20way.)%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-291872%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-291919%22%20slang%3D%22en-US%22%3ERe%3A%20Consolidating%20data%20from%20multiple%20worksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-291919%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you.%26nbsp%3B%26nbsp%3B%20I%20tried%20some%20of%20the%20choices%20and%20ended%20up%20doing%20the%20Professor%20Excel%20trial.%26nbsp%3B%20That%20was%20easy.%26nbsp%3B%20I%20guess%20I%20will%20have%20to%20purchase%20it%20if%20I%20need%20to%20do%20it%20again.%26nbsp%3B%20I%20couldn't%20really%20figure%20out%20the%20other%20methods.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-291897%22%20slang%3D%22en-US%22%3ERe%3A%20Consolidating%20data%20from%20multiple%20worksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-291897%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20general%20it's%20here%26nbsp%3B%3CFONT%3E%3CA%20href%3D%22https%3A%2F%2Fprofessor-excel.com%2Fmerge-excel-files-combine-workbooks-one-file%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fprofessor-excel.com%2Fmerge-excel-files-combine-workbooks-one-file%2F%3C%2FA%3E%3C%2FFONT%3E.%20What%20to%20use%20depend%20on%20are%20you%20on%20Excel%20Online%20only%20or%20not%20and%20is%20that%20static%20data%20(i.e.%20one%20time%20operation)%20or%20your%20files%20are%20updated%20from%20time%20to%20time.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Eg.  I have ten worksheets, all have same columns: email address, first name, last name.  Each worksheet has 100 rows filled.  I want to combine them into one worksheet that will have all the entries, i.e. 1000 lines of data.  How do I do this?   (I have simplified this question.  I actually have more columns and data, but the question is clearer this way.) Thanks.

2 Replies
Highlighted
Best Response confirmed by jesse5555 (New Contributor)
Solution

In general it's here https://professor-excel.com/merge-excel-files-combine-workbooks-one-file/. What to use depend on are you on Excel Online only or not and is that static data (i.e. one time operation) or your files are updated from time to time.

Highlighted

Thank you.   I tried some of the choices and ended up doing the Professor Excel trial.  That was easy.  I guess I will have to purchase it if I need to do it again.  I couldn't really figure out the other methods.