Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging two sheets with non-identical data
I have two sheets that has similiar data that I would like to make into one.
Below are examples of two sheets I would to merge and the ideal results: Examples of sheets: 1/07 2/07 3/07 Part# a 1 1 2 b 2 3 0 c 1 1 1 4/07 5/07 6/07 Part# b 1 1 2 c 2 3 0 d 1 1 1 Desired Result: 1/07 2/07 3/07 4/07 5/07 6/07 Part# a 1 1 2 0 0 0 b 2 3 0 1 1 2 c 1 1 1 2 3 0 d 0 0 0 1 1 1 Any help is apperciated. thanks, Robert |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging two sheets with non-identical data
The Data, Consolidation feature may be able to do what you want. Have you
looked at it? -- Jim "Robert_DubYa" wrote in message ... |I have two sheets that has similiar data that I would like to make into one. | Below are examples of two sheets I would to merge and the ideal results: | | Examples of sheets: | | 1/07 2/07 3/07 | Part# | a 1 1 2 | b 2 3 0 | c 1 1 1 | | | 4/07 5/07 6/07 | Part# | b 1 1 2 | c 2 3 0 | d 1 1 1 | | | Desired Result: | | 1/07 2/07 3/07 4/07 5/07 6/07 | Part# | a 1 1 2 0 0 0 | b 2 3 0 1 1 2 | c 1 1 1 2 3 0 | d 0 0 0 1 1 1 | | | | Any help is apperciated. | | thanks, | Robert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mult. w/sheets need identical view when opening (range, mag, cell) | Setting up and Configuration of Excel | |||
merging sheets | Excel Worksheet Functions | |||
Merging to identical Excel files | Excel Discussion (Misc queries) | |||
Moving cursor to identical cells across multiple sheets | Excel Discussion (Misc queries) | |||
merging data from two different sheets | Excel Discussion (Misc queries) |