Create a pivot table from the data, with Diameter in the row area,
length in the column area, and Count of Diameter in the data area.
In the page area, add Flat washer, and from its dropdown list, choose 1
Copy that pivot table, and paste the copy on a different sheet.
In the copy, remove Flat washer from the page area, and add Beveled
washer, and from its dropdown list, choose 1.