Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Another combine two files question....
I am trying to manipulate data from 2 reports into one sheet.
The first report is a flat file with a unique record key. The second file is a complicated disaster. It looks like the following: Record Number A Apples Record Number A Oranges Record Number B Apples Record Number B Peaches Record Number C Bananas I need it to look like: Apples Bananas Oranges Peaches Record Number A X X Record Number B X X Record Number C X Is there a fancy formula that could help me? I can do a vlookup and pull it in, that doesn't work for the multiple records for each record number. I think my brain is fried€¦ Thanks!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combine two files | Excel Discussion (Misc queries) | |||
merging my excel files | Excel Discussion (Misc queries) | |||
Cannot access read-only documents. | Excel Discussion (Misc queries) | |||
how to combine multiple files in ms excel | Excel Discussion (Misc queries) | |||
Combine multiple Excel files into one master | Excel Discussion (Misc queries) |