Joining Multiple Fields into One sheet as per common criteria

[Vicky92]

I have to combine datasets as per common fields/criteria into the same sheet. In my example (Record ID & Record ID type )  are common fields. I have attached input & output required tab for reference.

Input Tab :-

Record ID - I	Record ID Type I	Sales% -A	Revenue %-A	Record ID - II	Record ID Type II	Sales%-B	Net Income %-B	Record ID - III	Record ID Type III	Revenue %-C	Net Income %-C
10	A1	8%	8%	10	A1	6%	8%	20	B2	8%	8%
20	B2	5%	6%	20	B2	8%	6%	30	C3	6%	6%
30	C3	2%	7%	30	C3	4%	7%	40	D4	7%	7%
40	D4	1%	5%	40	D4	2%	5%	50	E5	5%	5%
				50	E5	8%	8%	60	F6	5%	8%
				60	F6	5%	5%
				70	G7	2%	2%
				80	H8	1%	6%
				90	I9	1%	7%

Output Tab Required :-

Record ID	Record ID Type	Sales% -A	Revenue %-A	Sales%-B	Net Income %-B	Revenue %-C	Net Income %-C
10	A1	8%	8%	6%	8%
20	B2	5%	6%	8%	6%	8%	8%
30	C3	2%	7%	4%	7%	6%	6%
40	D4	1%	5%	2%	5%	7%	7%
50	E5			8%	8%	5%	5%
60	F6			5%	5%	5%	8%
70	G7			2%	2%
80	H8			1%	6%
90	I9			1%	7%

[tochy]

[vstefano]

A simple way to solve it with a formula tool...