Organize and Sum Data

I think I am part of the way there, but I don't agree with the numbers you have for fittings.

This program reads the data and parses the information into a data table. I know you don't care about OLETS but they get caught up in this net too. The data table will be the basis for the report. I summarized the data in the pivot tables on the data sheet. We agree on the length of pipe and valves. However, I come up with two fittings to go along with the 6 inch pipe. I didn't pull out thickness, because I forgot to print it in the code. Also I did not yet pull out 90s and 45s I will do so when I get confirmation that I am heading in the right direction.

I will probably use SUMIFS formulas to pick out the pieces in the data for the report.