hello, I have two worksheets that have a number of part no.'s some of the part no.'s are the same on each sheet but have different data I am wanting to combine the sheets so the different data is consolidated to the same row for matching part no.'s I have managed to do this by data tab - get external data - from other sources - from microsoft query selecting the two worksheets and joining the part no.'s the problem I have is that all part no.'s that are unique on each sheet are ignored and lost can anyone think of how I can get this to work as I require? I have attached an example workbook where sheet 1 and 2 or my different worksheets sheet 3 is what I'm trying to achieve and sheet 3 is what I am getting using the method above.
Thanks for looking.