Combine multiple columns of value and get their totals from offset columns to the right

Evening,

What I am seeking to do is combine columns (T,V,XZ,AB,AD,AF), each one has a column to the right, that as a number (which is a quantity for the column to the left). I am seeking to have a pivot table, in which the items combine like item names get the total based on the qty to be based off the qty columns. I have attached a sample for reference.