Combine two sheets based on unique number with header detail data

[heryx]

I am trying to combine data from two sheets (sheet 1 & 2) in a MS Excel 2010 workbook. Each sheet contains unique numbers in column B. However, the data contained in Sheet 2 may have the same unique number multiple times.

For example :
Sheet1
id inv no inv date customer
HEADER PSI-16-12-27-001 12/27/16 INFOCOM
HEADER PSI-16-12-27-002 12/27/16 DUTACOM
HEADER PSI-16-12-27-003 12/27/16 CELL NET

Sheet2
id inv no item no qty
DETAIL PSI-16-12-27-001 STBX1000301 10
DETAIL PSI-16-12-27-001 STDR1000300 5
DETAIL PSI-16-12-27-002 MX10001 1
DETAIL PSI-16-12-27-002 MP10000 2
DETAIL PSI-16-12-27-003 TDR5000 7

I want result like this in Sheet3
HEADER PSI-16-12-27-001 12/27/16 INFOCOM
DETAIL PSI-16-12-27-001 STBX1000301 10
DETAIL PSI-16-12-27-001 STDR1000300 5
HEADER PSI-16-12-27-002 12/27/16 DUTACOM
DETAIL PSI-16-12-27-002 MX10001 1
DETAIL PSI-16-12-27-002 MP10000 2
HEADER PSI-16-12-27-003 12/27/16 CELL NET
DETAIL PSI-16-12-27-003 TDR5000 7

I'm already try using vlookup and pivot table but still cannot find solution for this.
Any suggestions would be appreciated!

Thanks

 

[Marcelo Branco]

Copy/Paste both data set, one below the other, to columns A:D of Sheet3,
Sort by column B

M.