excel consolidating
I have two spreadsheets I need to consolidate into one. The first looks as follows: w x y z a ** ** ** b ** ** ** c ** ** ** d ** ** ** The second one: j k l m a ** ** ** b ** ** ** b ++ ++ ++ c ** ** ** c ++ ++ ++ c -- -- -- d ** ** ** all the stars, plusses and dashes stand for various different data. the only thing the two spreadsheets have in common are column 1, and even in column 1, spreadsheet two has multiple entries of different data with the same row name. I need the finished product to look as follows: x y z k l m a ** ** ** ** ** ** b ** ** ** ** ** ** b ** ** ** ++ ++ ++ c ** ** ** ** ** ** c ** ** ** ++ ++ ++ c ** ** ** -- -- -- d ** ** ** ** ** ** In words, add the last three columns from spreadsheet 2 onto the end of spreadsheet one based on row name. When they are duplicate row names in spreadsheet 2, duplicate xyz as many times as necessary to attach every different instance of klm. I'm running excel 2002, and I also have access to 2003. I would appreciate any help you could give me on this matter. Thank you in advance. -- Eagle784 ------------------------------------------------------------------------ Eagle784's Profile: http://www.excelforum.com/member.php...o&userid=24261 View this thread: http://www.excelforum.com/showthread...hreadid=378688 |
I attached a .doc with proper spacing. Hopefully u'll be able to understand. Thanks again. +-------------------------------------------------------------------+ |Filename: excelhelp1.doc | |Download: http://www.excelforum.com/attachment.php?postid=3490 | +-------------------------------------------------------------------+ -- Eagle784 ------------------------------------------------------------------------ Eagle784's Profile: http://www.excelforum.com/member.php...o&userid=24261 View this thread: http://www.excelforum.com/showthread...hreadid=378688 |
All times are GMT +1. The time now is 06:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com