How To Lookup & Populate Data From Vertical Range To Horizontal?

[xlmaniac]

Dear All,
I have a sample data set across A1:I10 as follows.
There are 6 components(Unique count) that could feature in a docket number.
But this will vary from docket to docket depending on the nature of transport & destination location.
I need to populate the freight bill components from vertically to horizontally.
Could somebody help me out with the solution for the same?
[TABLE="width: 611"]
<tbody>[TR]
[TD]Docket Number[/TD]
[TD]Head[/TD]
[TD]Amount[/TD]
[TD]ADB[/TD]
[TD]ENG[/TD]
[TD]INV[/TD]
[TD]NT[/TD]
[TD]RT[/TD]
[TD]ST[/TD]
[/TR]
[TR]
[TD]500345[/TD]
[TD]RT[/TD]
[TD]87[/TD]
[TD]7[/TD]
[TD]15[/TD]
[TD]64[/TD]
[TD]0[/TD]
[TD]87[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]ENG[/TD]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]ADB[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]INV[/TD]
[TD]64[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]ADB[/TD]
[TD]ENG[/TD]
[TD]INV[/TD]
[TD]NT[/TD]
[TD]RT[/TD]
[TD]ST[/TD]
[/TR]
[TR]
[TD]500398[/TD]
[TD]ADB[/TD]
[TD]8[/TD]
[TD]8[/TD]
[TD]0[/TD]
[TD]98[/TD]
[TD]12[/TD]
[TD]0[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]INV[/TD]
[TD]98[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]NT[/TD]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]ST[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Column-A[/TD]
[TD]Column-B[/TD]
[TD]Column-C[/TD]
[TD]Column-D[/TD]
[TD]Column-E[/TD]
[TD]Column-F[/TD]
[TD]Column-G[/TD]
[TD]Column-H[/TD]
[TD]Column-I[/TD]
[/TR]
</tbody>[/TABLE]

 

[sheetspread]

Excel 2010
	A	B	C	D	E	F	G	H	I
1	Docket Number	Head	Amount	ADB	ENG	INV	NT	RT	ST
2	500345	RT	87	7	15	64	0	87	0
3		ENG	15
4		ADB	7
5		INV	64
6				ADB	ENG	INV	NT	RT	ST
7	500398	ADB	8	8	0	98	12	0	5
8		INV	98
9		NT	12
10		ST	5
Sheet2

Cell Formulas
Range	Formula
D2	=IFERROR(VLOOKUP(D1,$B2:$C5,2,0),0)

 

[xlmaniac]

Dear Sheetspread,
Thanks a lot for all your help.
Really appreciate the same.
Regards