Looking for a way to Merge Rows From One Sheet based on Serial Number to be added to another sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2238783%22%20slang%3D%22en-US%22%3ELooking%20for%20a%20way%20to%20Merge%20Rows%20From%20One%20Sheet%20based%20on%20Serial%20Number%20to%20be%20added%20to%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2238783%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20on%20Sheet%20in%20excel%20with%20many%20rows%20and%20columns%20of%20data.%26nbsp%3B%20Column%20A%20has%20serial%20numbers%20with%20no%20duplicates.%26nbsp%3B%20%26nbsp%3BI%20have%20another%20sheet%20with%20different%20rows%20and%20columns%20of%20data%20and%20column%20A%20also%20has%20serail%20numbers.%26nbsp%3B%20What%20i%20would%20like%20to%20do%20is%20append%20the%20data%20from%20sheet%202%20to%20the%20end%20of%20the%20row%20of%20the%20data%20in%20sheet%201.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESheet%201%20(Serial%20Number%20in%20A)%20Last%20column%20BO.%26nbsp%3B%20I%20would%20like%20to%20append%20data%20From%20Sheet%202%20Starting%20With%20Column%20BP%20if%20the%20serail%20number%20in%20A%20Sheet%202%20matches%20serail%20number%20in%20A%20sheet%201.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2238783%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2239130%22%20slang%3D%22en-US%22%3ERe%3A%20Looking%20for%20a%20way%20to%20Merge%20Rows%20From%20One%20Sheet%20based%20on%20Serial%20Number%20to%20be%20added%20to%20another%20she%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2239130%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1010059%22%20target%3D%22_blank%22%3E%40Steve099%3C%2FA%3E%26nbsp%3BThis%20can%20be%20done%20in%20various%20ways.%20If%20you%20are%20an%20MS365%20subscriber%20in%20the%20Current%20Channel%20you%20could%20use%20the%20new%20FILTER%20function.%20Alternatively%2C%20use%20a%20series%20of%20traditional%20VLOOKUP%20functions%20or%20its%20successor%20XLOOKUP.%20Exactly%20how%2C%20depends%20on%20the%20actual%20structure%20of%20your%20data%20sets.%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20then%20there%20is%20always%20Power%20Query%20(provided%20you%20are%20%3CSTRONG%3Enot%3C%2FSTRONG%3E%20on%20Excel%20for%20Mac)%2C%20that%20can%20fairly%20easily%20merge%20large%20data%20sets%2C%20without%20copying%2C%20pasting%20or%20a%20great%20number%20of%20formulae.%3C%2FP%3E%3CP%3EIf%20you%20could%20share%20and%20example%20of%20let's%20say%2010%20rows%20from%20each%20data%20set%20(with%20matching%20serial%20numbers%2C%20of%20course)%2C%20I%20or%20someone%20else%20here%20could%20provide%20the%20solution%20you%20need.%20And%20please%20mention%20what%20Excel%20version%20you%20are%20on.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have on Sheet in excel with many rows and columns of data.  Column A has serial numbers with no duplicates.   I have another sheet with different rows and columns of data and column A also has serail numbers.  What i would like to do is append the data from sheet 2 to the end of the row of the data in sheet 1.

 

Sheet 1 (Serial Number in A) Last column BO.  I would like to append data From Sheet 2 Starting With Column BP if the serail number in A Sheet 2 matches serail number in A sheet 1.

 

 

3 Replies

@Steve099 This can be done in various ways. If you are an MS365 subscriber in the Current Channel you could use the new FILTER function. Alternatively, use a series of traditional VLOOKUP functions or its successor XLOOKUP. Exactly how, depends on the actual structure of your data sets. 

And then there is always Power Query (provided you are not on Excel for Mac), that can fairly easily merge large data sets, without copying, pasting or a great number of formulae.

If you could share and example of let's say 10 rows from each data set (with matching serial numbers, of course), I or someone else here could provide the solution you need. And please mention what Excel version you are on.

@Riny_van_Eekelen 

 

Thanks for the suggestions.  Could I also use INDEX (Match  or is vlookup better?.  I added an example of what i have.

@Steve099 Sure, I believe the attached file contains a possible solution in Sheet1, from column BO and onwards.