Need help with Subtotaling

[alan.sluder]

I am trying to do be able to get a total of materials by spec, type and then size. I have sorted my data by the spec, type and then size.

Example:

I want to know the total footage of say 3" pipe by the PPL45 spec...in this example 48.

Excel 2010
	A	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
6	MTO
7																			Install			Material
8	Item No.	Insulated Y/N	Line #	P&ID #	ISO #	Spool #	Valve ID	Size	Size	Description	Material or Spec	Paint Spec	By	Item Code		Qty	Sets	Unit	Unit M.H.	Difficulty Factor	Total M.H.	Unit Cost	Total
9	344		01308	P017162	SK-P158-01308-01/02			3		45 D Elbow, A395 DI, B16.5, CL 150, Fixed Flg, PP Liner, Crane Resistoflex Series E500P1VV0NXXX	PPL45	DC-1	O	E	2	2	1	EA	4.00	1.00	8.00	0	0
10	1375		01550	P017139	SK-P158-01550-01			4		90 D Elbow, A395 DI, B16.5, CL 150, Fixed Flg, PP Liner, Crane Resistoflex Series E900P1VV0NXXX	PPL45	DC-1	O	V	2	2	1	EA	2.00	1.00	4.00	0	0
11	347		01308	P017162	SK-P158-01308-01/02			3		90 D Elbow, A395 DI, B16.5, CL 150, Fixed Flg, PP Liner, Crane Resistoflex Series E900P1VV0NXXX	PPL45	DC-1	O	P	1	20	1	EA	0.41	1.00	8.20	0	0
12	352		01308	P017162	SK-P158-01308-01/02			3		90 D Elbow, A395 DI, B16.5, CL 150, Fixed Flg, PP Liner, Crane Resistoflex Series E900P1VV0NXXX	PPL45	DC-1	O	E	2	2	1	EA	4.00	1.00	8.00	0	0
13	1376		01550	P017139	SK-P158-01550-01		BA40	4		Ball Valve, BA40, RFFE, CL 150, Full Port	PPL45	DC-1	O	V	1	1	1	EA	2.00	1.00	2.00	0	0
14	1372		01550	P017139	SK-P158-01550-01			4		BNG Set	PPL45	DC-1	F	B	2	2	1	EA	1.30	1.00	2.60	0	0
15	343		01308	P017162	SK-P158-01308-01/02			3		BNG Set	PPL45	DC-1	F	B	4	4	1	EA	1.00	1.00	4.00	0	0
16	350		01308	P017162	SK-P158-01308-01/02			3		BNG Set	PPL45	DC-1	F	B		0	1	EA	1.00	1.00	0.00	0	0
17	1377		01550	P017139	SK-P158-01550-01		CK24	4		Check Valve, Swing, CK24, Wafer RF, CL150	PPL45	DC-1	O	V	1	1	1	EA	2.00	1.00	2.00	0	0
18	348		01308	P017162	SK-P158-01308-01/02			3		Pipe Support	PPL45	DC-1	S		3	3	1	EA	3.00	1.50	13.50	0	0
19	1374		01550	P017139	SK-P158-01550-01			4		Pipe, Swaged, Lined A587, B36.10M, CL 150, RFFEWG, Full Vacuum rated with locked PP Liner w/ ductile iron A395 fixed thd flange both ends Crane Resistoflex Series GS101220XXX S-STD	PPL45	DC-1	O	V	1	1	1	EA	2.00	1.00	2.00	0	0
20	345		01308	P017162	SK-P158-01308-01/02			3		Pipe, Swaged, Lined A587, B36.10M, CL 150, RFFEWG, Full Vacuum rated with locked PP Liner w/ ductile iron A395 fixed thd flange both ends Crane Resistoflex Series GS101220XXX S-STD	PPL45	DC-1	O	E	20	20	1	EA	4.00	1.00	80.00	0	0
21	346		01308	P017162	SK-P158-01308-01/02			3		Pipe, Swaged, Lined A587, B36.10M, CL 150, RFFEWG, Full Vacuum rated with locked PP Liner w/ ductile iron A395 fixed thd flange both ends Crane Resistoflex Series GS101220XXX S-STD	PPL45	DC-1	O	P	11.11	20	1	EA	0.41	1.00	8.20	0	0
22	351		01308	P017162	SK-P158-01308-01/02			3		Pipe, Swaged, Lined A587, B36.10M, CL 150, RFFEWG, Full Vacuum rated with locked PP Liner w/ ductile iron A395 fixed thd flange both ends Crane Resistoflex Series GS101220XXX S-STD	PPL45	DC-1	O	P	13.25	20	1	EA	0.41	1.00	8.20	0	0
23	353		01308	P017162	SK-P158-01308-01/02			3		Pipe, Swaged, Lined A587, B36.10M, CL 150, RFFEWG, Full Vacuum rated with locked PP Liner w/ ductile iron A395 fixed thd flange both ends Crane Resistoflex Series GS101220XXX S-STD	PPL45	DC-1	O	P	3.64	20	1	EA	0.41	1.00	8.20	0	0
24	354		01308	P017162	SK-P158-01308-01/02			3		Pipe, Swaged, Lined A587, B36.10M, CL 150, RFFEWG, Full Vacuum rated with locked PP Liner w/ ductile iron A395 fixed thd flange both ends Crane Resistoflex Series GS101220XXX S-STD	PPL45	DC-1	O	P	0.58	20	1	EA	0.41	1.00	8.20	0	0
25	1378		01550	P017139	SK-P158-01550-01	MK-P158-01550-1/2/3/4		4		Spool Piece	PPL45	DC-1	F	P	4	4	1	EA	0.53	1.50	3.18	0	0
26	349		01308	P017162	SK-P158-01308-01/02	MK-P158-01308-1/2/3/4/5		3		Spool Piece	PPL45	DC-1	F	P	5	5	1	EA	0.41	1.50	3.08	0	0
27	355		01308	P017162	SK-P158-01308-01/02	MK-P158-01308-6/7/8/9/10		3		Spool Piece	PPL45	DC-1	F	P	5	5	1	EA	0.41	1.50	3.08	0	0
28	1373		01550	P017139	SK-P158-01550-01			4	3	Tee Red, A395 DI, B16.5, CL 150, Fixed Flg, PP Liner, Crane Resistoflex Series TR00P1VVVNXXX	PPL45	DC-1	O	V	1	1	1	EA	2.00	1.00	2.00	0	0
29											PPL45 Total				82.58						178.43		0
30	416		01425	P017138	SK-P158-01425-01			3		90 LR, B16.9, BE, A234 WPB, S-STD	PS27H	DC-1	S	E	1	1	1	EA	4.00	1.00	4.00	0	0
31	515		01428	P017138	SK-P158-01428-01			3		90 LR, B16.9, BE, A234 WPB, S-STD	PS27H	DC-1	S	E	2	2	1	EA	4.00	1.00	8.00	0	0
32	380		01311	P017162	SK-P158-01311-01/02			2		90 LR, B16.9, BE, A234 WPB, S-XS	PS27H	DC-1	S	E	5	5	1	EA	3.22	1.00	16.10	0	0
33	387		01311	P017162	SK-P158-01311-01/02			2		90 LR, B16.9, BE, A234 WPB, S-XS	PS27H	DC-1	S	E		0	1	EA	3.22	1.00	0.00	0	0
34	728		01461	P017139	SK-P158-01461-01			1		90 LR, B16.9, BE, A234 WPB, S-XS	PS27H	DC-1	S	E	1	1	1	EA	1.64	1.00	1.64	0	0
35	1392		01552	P017139	SK-P158-01552-01			1		90 LR, B16.9, BE, A234 WPB, S-XS	PS27H	DC-1	S	E	3	3	1	EA	1.64	1.00	4.92	0	0
36	1402		01553	P017139	SK-P158-01553-01/02			1		90 LR, B16.9, BE, A234 WPB, S-XS	PS27H	DC-1	S	E	1	1	1	EA	1.64	1.00	1.64	0	0
37	1414		01553	P017139	SK-P158-01553-01/02			1		90 LR, B16.9, BE, A234 WPB, S-XS	PS27H	DC-1	S	E	2	2	1	EA	1.64	1.00	3.28	0	0
38	955		01476	P017140	SK-P158-01476-01			1/2		90 LR, B16.9, BE, A234 WPB, S-XS	PS27H	DC-1	S	E	3	3	1	EA	0.86	1.00	2.58	0	0
39	1408		01553	P017139	SK-P158-01553-01/02		BA04V	1/2		Ball Valve, BA04V, FTE, WOG 2000, Full Port	PS27H	DC-1	O	V	1	1	1	EA	1.00	1.00	1.00	0	0
40	423		01425	P017138	SK-P158-01425-01		BA10	3		Ball Valve, BA10, RFFE, CL 150, Standard Port	PS27H	DC-1	O	V	1	1	1	EA	2.00	1.00	2.00	0	0
41	394		01311	P017162	SK-P158-01311-01/02		BA10	1		Ball Valve, BA10, RFFE, CL 150, Standard Port	PS27H	DC-1	O	V		0	1	EA	2.00	1.00	0.00	0	0
42	425		01425	P017138	SK-P158-01425-01		BA10	1		Ball Valve, BA10, RFFE, CL 150, Standard Port	PS27H	DC-1	O	V	1	1	1	EA	2.00	1.00	2.00	0	0
43	744		01462	P017139	SK-P158-01462-01		BA10	1		Ball Valve, BA10, RFFE, CL 150, Standard Port	PS27H	DC-1	O	V	1	1	1	EA	2.00	1.00	2.00	0	0
44	1396		01552	P017139	SK-P158-01552-01		BA10	1		Ball Valve, BA10, RFFE, CL 150, Standard Port	PS27H	DC-1	O	V	1	1	1	EA	2.00	1.00	2.00	0	0
45	1407		01553	P017139	SK-P158-01553-01/02		BA10	1		Ball Valve, BA10, RFFE, CL 150, Standard Port	PS27H	DC-1	O	V	1	1	1	EA	2.00	1.00	2.00	0	0
46	1422		01553	P017139	SK-P158-01553-01/02		BA10	1		Ball Valve, BA10, RFFE, CL 150, Standard Port	PS27H	DC-1	O	V	1	1	1	EA	2.00	1.00	2.00	0	0
47	962		01476	P017140	SK-P158-01476-01		BA10	1/2		Ball Valve, BA10, RFFE, CL 150, Standard Port	PS27H	DC-1	O	V	2	2	1	EA	1.00	1.00	2.00	0	0
48	973		01477	P017140	SK-P158-01477-01		BA10	1/2		Ball Valve, BA10, RFFE, CL 150, Standard Port	PS27H	DC-1	O	V	2	2	1	EA	1.00	1.00	2.00	0	0
49	963		01476	P017140	SK-P158-01476-01		BA123V	1/2		Ball Valve, BA123V, FTE, CL600, Standard Port	PS27H	DC-1	O	V	1	1	1	EA	1.00	1.00	1.00	0	0
50	974		01477	P017140	SK-P158-01477-01		BA123V	1/2		Ball Valve, BA123V, FTE, CL600, Standard Port	PS27H	DC-1	O	V	1	1	1	EA	1.00	1.00	1.00	0	0
51	421		01425	P017138	SK-P158-01425-01			3		BNG Set	PS27H	DC-1	F	B	6	6	1	EA	1.00	1.00	6.00	0	0
52	517		01428	P017138	SK-P158-01428-01			3		BNG Set	PS27H	DC-1	F	B	1	1	1	EA	1.00	1.00	1.00	0	0
53	392		01311	P017162	SK-P158-01311-01/02			2		BNG Set	PS27H	DC-1	F	B		0	1	EA	0.80	1.00	0.00	0	0
54	393		01311	P017162	SK-P158-01311-01/02			1		BNG Set	PS27H	DC-1	F	B		0	1	EA	0.80	1.00	0.00	0	0
55	422		01425	P017138	SK-P158-01425-01			1		BNG Set	PS27H	DC-1	F	B	2	2	1	EA	0.80	1.00	1.60	0	0
56	734		01461	P017139	SK-P158-01461-01			1		BNG Set	PS27H	DC-1	F	B	2	2	1	EA	0.80	1.00	1.60	0	0
57	743		01462	P017139	SK-P158-01462-01			1		BNG Set	PS27H	DC-1	F	B	4	4	1	EA	0.80	1.00	3.20	0	0
58	1395		01552	P017139	SK-P158-01552-01			1		BNG Set	PS27H	DC-1	F	B	2	2	1	EA	0.80	1.00	1.60	0	0
59	1406		01553	P017139	SK-P158-01553-01/02			1		BNG Set	PS27H	DC-1	F	B	3	3	1	EA	0.80	1.00	2.40	0	0
60	1420		01553	P017139	SK-P158-01553-01/02			1		BNG Set	PS27H	DC-1	F	B	3	3	1	EA	0.80	1.00	2.40	0	0
61	961		01476	P017140	SK-P158-01476-01			1/2		BNG Set	PS27H	DC-1	F	B	4	4	1	EA	0.80	1.00	3.20	0	0
62	972		01477	P017140	SK-P158-01477-01			1/2		BNG Set	PS27H	DC-1	F	B	4	4	1	EA	0.80	1.00	3.20	0	0
63	424		01425	P017138	SK-P158-01425-01		CK04	3		Check Valve, Swing, CK03, RFFE, CL150	PS27H	DC-1	O	V	1	1	1	EA	2.00	1.00	2.00	0	0
64	1421		01553	P017139	SK-P158-01553-01/02		CK03	1		Check Valve, Swing, CK03, RFFE, CL150	PS27H	DC-1	O	V	1	1	1	EA	2.00	1.00	2.00	0	0
65	1413		01553	P017139	SK-P158-01553-01/02			1	3/4	Conc Red, B16.9, BE x BE, A234 WPB, S-XS x S-XS	PS27H	DC-1	S	R	1	1	1	EA	1.44	1.00	1.44	0	0
66	384		01311	P017162	SK-P158-01311-01/02			2		Field Weld	PS27H	DC-1	F		3	3	1	EA	1.10	1.00	3.30	0	0
67	397		01311	P017162	SK-P158-01311-01/02			2		Field Weld	PS27H	DC-1	F		2	2	1	EA	1.10	1.00	2.20	0	0
68	1398		01552	P017139	SK-P158-01552-01			1		Field Weld	PS27H	DC-1	F		1	1	1	EA	0.80	1.00	0.80	0	0
69	1410		01553	P017139	SK-P158-01553-01/02			1		Field Weld	PS27H	DC-1	F		1	1	1	EA	0.80	1.00	0.80	0	0
70	391		01311	P017162	SK-P158-01311-01/02			1	1/2	Flg, THRD, A105, B16.5, CL 150, RFFE, S-STD	PS27H	DC-1	F	F		0	1	EA	1.20	1.00	0.00	0	0
71	420		01425	P017138	SK-P158-01425-01			1	1/2	Flg, THRD, A105, B16.5, CL 150, RFFE, S-STD	PS27H	DC-1	F	F	1	1	1	EA	1.20	1.00	1.20	0	0
72	742		01462	P017139	SK-P158-01462-01			1	1/2	Flg, THRD, A105, B16.5, CL 150, RFFE, S-STD	PS27H	DC-1	F	F	1	1	1	EA	1.20	1.00	1.20	0	0
73	733		01461	P017139	SK-P158-01461-01			1		Flg, THRD, A105, B16.5, CL 150, RFFE, S-STD	PS27H	DC-1	F	F	1	1	1	EA	1.20	1.00	1.20	0	0
74	960		01476	P017140	SK-P158-01476-01			1/2		Flg, THRD, A105, B16.5, CL 150, RFFE, S-STD	PS27H	DC-1	F	F	1	1	1	EA	0.70	1.00	0.70	0	0
75	971		01477	P017140	SK-P158-01477-01			1/2		Flg, THRD, A105, B16.5, CL 150, RFFE, S-STD	PS27H	DC-1	F	F	1	1	1	EA	0.70	1.00	0.70	0	0
76	417		01425	P017138	SK-P158-01425-01			3		Flg, WN, A105, B16.5, CL 150, RFFE, S-STD	PS27H	DC-1	S	F	6	6	1	EA	2.50	1.00	15.00	0	0
77	516		01428	P017138	SK-P158-01428-01			3		Flg, WN, A105, B16.5, CL 150, RFFE, S-STD	PS27H	DC-1	S	F	1	1	1	EA	2.50	1.00	2.50	0	0
78	388		01311	P017162	SK-P158-01311-01/02			2		Flg, WN, A105, B16.5, CL 150, RFFE, S-STD	PS27H	DC-1	S	F		0	1	EA	2.10	1.00	0.00	0	0
79	381		01311	P017162	SK-P158-01311-01/02			2		Flg, WN, A105, B16.5, CL 150, RFFE, S-XS	PS27H	DC-1	S	F	1	1	1	EA	2.10	1.00	2.10	0	0
80	389		01311	P017162	SK-P158-01311-01/02			1		Flg, WN, A105, B16.5, CL 150, RFFE, S-XS	PS27H	DC-1	S	F		0	1	EA	1.20	1.00	0.00	0	0
81	418		01425	P017138	SK-P158-01425-01			1		Flg, WN, A105, B16.5, CL 150, RFFE, S-XS	PS27H	DC-1	S	F	1	1	1	EA	1.20	1.00	1.20	0	0
82	730		01461	P017139	SK-P158-01461-01			1		Flg, WN, A105, B16.5, CL 150, RFFE, S-XS	PS27H	DC-1	S	F	1	1	1	EA	1.20	1.00	1.20	0	0
83	739		01462	P017139	SK-P158-01462-01			1		Flg, WN, A105, B16.5, CL 150, RFFE, S-XS	PS27H	DC-1	S	F	2	2	1	EA	1.20	1.00	2.40	0	0
84	1393		01552	P017139	SK-P158-01552-01			1		Flg, WN, A105, B16.5, CL 150, RFFE, S-XS	PS27H	DC-1	S	F	2	2	1	EA	1.20	1.00	2.40	0	0
85	1404		01553	P017139	SK-P158-01553-01/02			1		Flg, WN, A105, B16.5, CL 150, RFFE, S-XS	PS27H	DC-1	S	F	3	3	1	EA	1.20	1.00	3.60	0	0
86	1417		01553	P017139	SK-P158-01553-01/02			1		Flg, WN, A105, B16.5, CL 150, RFFE, S-XS	PS27H	DC-1	S	F	2	2	1	EA	1.20	1.00	2.40	0	0
87	957		01476	P017140	SK-P158-01476-01			1/2		Flg, WN, A105, B16.5, CL 150, RFFE, S-XS	PS27H	DC-1	S	F	3	3	1	EA	0.70	1.00	2.10	0	0
88	968		01477	P017140	SK-P158-01477-01			1/2		Flg, WN, A105, B16.5, CL 150, RFFE, S-XS	PS27H	DC-1	S	F	3	3	1	EA	0.70	1.00	2.10	0	0
89	745		01462	P017139	SK-P158-01462-01			1		Instrument Tag PT-158550	PS27H	DC-1	O	V	1	1	1	EA	2.00	1.00	2.00	0	0
90	738		01462	P017139	SK-P158-01462-01			1		Nipple, Pipe, SMLS, A106 GR B, A733/B36.10M, 3" Long, BOE/TOE, S-XS	PS27H	DC-1	S	P	1	1	1	EA	0.25	1.00	0.25	0	0
91	1415		01553	P017139	SK-P158-01553-01/02			1		Nipple, Pipe, SMLS, A106 GR B, A733/B36.10M, 3" Long, BOE/TOE, S-XS	PS27H	DC-1	S	P	2	2	1	EA	0.25	1.00	0.50	0	0
92	1416		01553	P017139	SK-P158-01553-01/02			3/4		Nipple, Pipe, SMLS, A106 GR B, A733/B36.10M, 3" Long, BOE/TOE, S-XS	PS27H	DC-1	S	P	1	1	1	EA	0.24	1.00	0.24	0	0
93	954		01476	P017140	SK-P158-01476-01			1/2		Nipple, Pipe, SMLS, A106 GR B, A733/B36.10M, 3" Long, BOE/TOE, S-XS	PS27H	DC-1	S	P	4	4	1	EA	0.23	1.00	0.92	0	0
MTO

 

[CharlesChuckieCharles]

You'll probably need to give more specific info which colums are which, and where you want the result

(you could look at SUMIFS if you running 2007+)

 

[alan.sluder]

More specifically,

I am looking to do a totaling that looks similar to the example below where I sort by column L - Material or Spec, then column K -Description and finally column I - Size

Excel 2010
	A	C	D	E	F	G	H	I	J	K	L	M	N	O	P
8	Item No.	Insulated Y/N	System	Service	Location	Valve ID	Size	Description	Material or Spec	By	Item Code		Qty	Sets	Unit
9	1						1	Pipe, SMLS, A106 Gr B, B36.10, 10M PE, S-XS		O	P	448	440	1	EA
10	2						2	Pipe, SMLS, A106 Gr B, B36.10, 10M BE, S-XS		O	P	312	320	1	EA
11	3						2	Pipe, SMLS, A106 Gr B, B36.10, 10M BE, S-XS		O	P	146	140	1	EA
12	4						3	Pipe, SMLS, A106 Gr B, B36.10, 10M BE, S-STD		O	P	73	80	1	EA
13	5						3	Pipe, SMLS, A106 Gr B, B36.10, 10M BE, S-XS		O	P	775	780	1	EA
14	6						4	Pipe, SMLS, A106 Gr B, B36.10, 10M BE, S-STD		O	P	45	40	1	EA
15	7						4	Pipe, SMLS, A106 Gr B, B36.10, 10M BE, S-XS		O	P	296	300	1	EA
16	8						6	Pipe, SMLS, A106 Gr B, B36.10, 10M BE, S-STD		O	P	58	60	1	EA
17	9						6	Trunnion Pipe, SMLS, A106 GR B, B36.10M, BE, S-XS		O	P	3	20	1	EA
18	10						8	Pipe, SMLS, A106 Gr B, B36.10, 10M BE, S-STD		O	P	49	40	1	EA
19	11						10	Pipe, SMLS, A106 Gr B, B36.10, 10M BE, S-STD		O	P	341	340	1	EA
20	12						1/2	Pipe, SMLS, A106 Gr B, B36.10, 10M BE, S-XS		O	P	7	20	1	EA
21	13						1 1/2	Pipe, SMLS, A106 Gr B, B36.10, 10M BE, S-XS		O	P	64	60	1	EA
22	14						1	90 LR, B16.9, BE, A234 WPB, S-XS		O	E	55	55	1	EA
23	15						2	90 LR, B16.9, BE, A234 WPB, S-XS		O	E	21	21	1	EA
24	16						2	90 LR, B16.9, BE, A234 WPB, S-XS		O	E	10	10	1	EA
25	17						3	90 LR, B16.9, BE, A234 WPB, S-STD		O	E	15	15	1	EA
26	18						3	90 LR, B16.9, BE, A234 WPB, S-XS		O	E	43	43	1	EA
27	19						4	90 LR, B16.9, BE, A234 WPB, S-STD		O	E	14	14	1	EA
28	20						4	90 LR, B16.9, BE, A234 WPB, S-XS		O	E	32	32	1	EA
29	21						10	90 LR, B16.9, BE, A234 WPB, S-STD		O	E	1	1	1	EA
30	22						1/2	90 LR, B16.9, BE, A234 WPB, S-XS		O	E	10	10	1	EA
31	23						1 1/2	90 LR, B16.9, BE, A234 WPB, S-XS		O	E	23	23	1	EA
32	24						1	45 LR, B16.9, BE, A234 WPB, S-XS		O	E	1	1	1	EA
33	25						3	90 LR, B16.9, BE, A234 WPB, S-STD		O	E	1	1	1	EA
34	26						3	45 LR, B16.9, BE, A234 WPB, S-XS		O	E	7	7	1	EA
35	27						4	90 LR, B16.9, BE, A234 WPB, S-STD		O	E	1	1	1	EA
36	28						4	45 LR, B16.9, BE, A234 WPB, S-XS		O	E	4	4	1	EA
37	29						8	90 LR, B16.9, BE, A234 WPB, S-STD		O	E	1	1	1	EA
38	30						10	90 LR, B16.9, BE, A234 WPB, S-STD		O	E	2	2	1	EA
39	31						1 1/2	45 LR, B16.9, BE, A234 WPB, S-XS		O	E	2	2	1	EA
40	32						1 1/2	x 1/2" Tee Red, B16.9, BE x BE, A234, WPB, S-XS x S-XS		O	V	3	3	1	EA
41	33						4	x 3" Tee Red, B16.9, BE x BE, A234, WPB, S-XS x S-XS		O	V	2	2	1	EA
42	34						6	x 3" Tee Red, B16.9, BE x BE, A234, WPB, S-XS x S-XS		O	V	1	1	1	EA
43	35						1	x 1/2" Swage, Concentric, A234 WPB, MSS-SP-95/B36.10M, BLE/TSE, S-XS x S-XS		O	R	4	4	1	EA
44	36						1	x 3/4" Conc Red, B16.9, BE x BE, A234 WPB, S-XS x S-XS		O	R	5	5	1	EA
45	37						1 1/2	x 1" Conc Red, B16.9, BE x BE, A234 WPB, S-XS x S-XS		O	R	2	2	1	EA
46	38						2	x 1" Conc Red, B16.9, BE x BE, A234 WPB, S-XS x S-XS		O	R	1	1	1	EA
47	39						3	x 2" Conc Red, B16.9, BE x BE, A234 WPB, S-STD x S-STD		O	R	1	1	1	EA
48	40						3	x 2" Conc Red, B16.9, BE x BE, A234 WPB, S-XS x S-XS		O	R	2	2	1	EA
49	41						4	x 1 1/2" Conc Red, B16.9, BE x BE, A234 WPB, S-XS x S-XS		O	R	1	1	1	EA
50	42						4	x 2" Conc Red, B16.9, BE x BE, A234 WPB, S-XS x S-XS		O	R	5	5	1	EA
51	43						4	x 3" Conc Red, B16.9, BE x BE, A234 WPB, S-STD x S-STD		O	R	6	6	1	EA
52	44						8	x 4" Conc Red, B16.9, BE x BE, A234 WPB, S-STD x S-STD		O	R	1	1	1	EA
53	45						12	x 8" Conc Red, B16.9, BE x BE, A234 WPB, S-STD x S-STD		O	R	1	1	1	EA
54	46						3	x 2" Ecc Red, B16.9, BE x BE, A234 WPB, S-XS x S-XS		O	R	1	1	1	EA
55	47						4	x 2" Ecc Red, B16.9, BE x BE, A234 WPB, S-XS x S-XS		O	R	1	1	1	EA
56	48						4	x 3" Ecc Red, B16.9, BE x BE, A234 WPB, S-XS x S-XS		O	R	1	1	1	EA
57	49						1	Tee, B16.9, BE, A234 WPB, S-XS		O	T	13	13	1	EA
Owner Furnished Pipe

 

[c_m_s_jr]

Have you considered using a pivot table?