Displaying only values that have a number

[jamesmev]

I am working on a sheet where we have a list of 1100 item codes in row A.
In Row B we would note the volume needed of item code in row a.

On the second sheet I need the sheet to only display the item codes that have a volume and then the volume listed in the column to the right for each code used. Not displaying any item code with a zero volume

Example
Sheet 1

Item Code Volume

12323 5
34234
43543543 4
3435
2343245 1

sheet 2 returns
A B C D E F etc...
1 Item Code volume Item Code Volume Item Code Volume
2 12323 5 43543543 4 2343245 1

 

[Scott T]

Excel 2010
	A	B
1	item code	Volume
2	12323	5
3	34234
4	43543543	4
5	3435
6	2343245	1
Sheet1

Excel 2010
	A	B	C	D	E	F	G	H
1	item code	Volume	item code	Volume	item code	Volume	item code	Volume
2	12323	5	43543543	4	2343245	1
Sheet2

Cell Formulas
Range	Formula
A2	{=IFERROR(IF(A1="volume",INDEX(Sheet1!$B$2:$B$6,SMALL(IF(Sheet1!$B$2:$B$6<>"",ROW(Sheet1!$B$2:$B$6)-ROW(Sheet1!$B$2)+1),COUNTIF($A$1:A1,"item code"))),INDEX(Sheet1!$A$2:$A$6,SMALL(IF(Sheet1!$B$2:$B$6<>"",ROW(Sheet1!$B$2:$B$6)-ROW(Sheet1!$B$2)+1),COUNTIF($A$1:A1,"item code")))),"")}
B2	{=IFERROR(IF(B1="volume",INDEX(Sheet1!$B$2:$B$6,SMALL(IF(Sheet1!$B$2:$B$6<>"",ROW(Sheet1!$B$2:$B$6)-ROW(Sheet1!$B$2)+1),COUNTIF($A$1:B1,"item code"))),INDEX(Sheet1!$A$2:$A$6,SMALL(IF(Sheet1!$B$2:$B$6<>"",ROW(Sheet1!$B$2:$B$6)-ROW(Sheet1!$B$2)+1),COUNTIF($A$1:B1,"item code")))),"")}
C2	{=IFERROR(IF(C1="volume",INDEX(Sheet1!$B$2:$B$6,SMALL(IF(Sheet1!$B$2:$B$6<>"",ROW(Sheet1!$B$2:$B$6)-ROW(Sheet1!$B$2)+1),COUNTIF($A$1:C1,"item code"))),INDEX(Sheet1!$A$2:$A$6,SMALL(IF(Sheet1!$B$2:$B$6<>"",ROW(Sheet1!$B$2:$B$6)-ROW(Sheet1!$B$2)+1),COUNTIF($A$1:C1,"item code")))),"")}
D2	{=IFERROR(IF(D1="volume",INDEX(Sheet1!$B$2:$B$6,SMALL(IF(Sheet1!$B$2:$B$6<>"",ROW(Sheet1!$B$2:$B$6)-ROW(Sheet1!$B$2)+1),COUNTIF($A$1:D1,"item code"))),INDEX(Sheet1!$A$2:$A$6,SMALL(IF(Sheet1!$B$2:$B$6<>"",ROW(Sheet1!$B$2:$B$6)-ROW(Sheet1!$B$2)+1),COUNTIF($A$1:D1,"item code")))),"")}
E2	{=IFERROR(IF(E1="volume",INDEX(Sheet1!$B$2:$B$6,SMALL(IF(Sheet1!$B$2:$B$6<>"",ROW(Sheet1!$B$2:$B$6)-ROW(Sheet1!$B$2)+1),COUNTIF($A$1:E1,"item code"))),INDEX(Sheet1!$A$2:$A$6,SMALL(IF(Sheet1!$B$2:$B$6<>"",ROW(Sheet1!$B$2:$B$6)-ROW(Sheet1!$B$2)+1),COUNTIF($A$1:E1,"item code")))),"")}
F2	{=IFERROR(IF(F1="volume",INDEX(Sheet1!$B$2:$B$6,SMALL(IF(Sheet1!$B$2:$B$6<>"",ROW(Sheet1!$B$2:$B$6)-ROW(Sheet1!$B$2)+1),COUNTIF($A$1:F1,"item code"))),INDEX(Sheet1!$A$2:$A$6,SMALL(IF(Sheet1!$B$2:$B$6<>"",ROW(Sheet1!$B$2:$B$6)-ROW(Sheet1!$B$2)+1),COUNTIF($A$1:F1,"item code")))),"")}
G2	{=IFERROR(IF(G1="volume",INDEX(Sheet1!$B$2:$B$6,SMALL(IF(Sheet1!$B$2:$B$6<>"",ROW(Sheet1!$B$2:$B$6)-ROW(Sheet1!$B$2)+1),COUNTIF($A$1:G1,"item code"))),INDEX(Sheet1!$A$2:$A$6,SMALL(IF(Sheet1!$B$2:$B$6<>"",ROW(Sheet1!$B$2:$B$6)-ROW(Sheet1!$B$2)+1),COUNTIF($A$1:G1,"item code")))),"")}
H2	{=IFERROR(IF(H1="volume",INDEX(Sheet1!$B$2:$B$6,SMALL(IF(Sheet1!$B$2:$B$6<>"",ROW(Sheet1!$B$2:$B$6)-ROW(Sheet1!$B$2)+1),COUNTIF($A$1:H1,"item code"))),INDEX(Sheet1!$A$2:$A$6,SMALL(IF(Sheet1!$B$2:$B$6<>"",ROW(Sheet1!$B$2:$B$6)-ROW(Sheet1!$B$2)+1),COUNTIF($A$1:H1,"item code")))),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.