Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |