trouble creating pivot table

I have a table with various cable sizes and routing information. (See attached excel file) In column A is a description of a cable, colum B is a material code of the cable, colum C is the cable size, column D is quantity of cable, E is area of the cable, and columns F to T contain routing section numbers in which the cable will travel through.

What I would like to do is create a pivot table that allows for selecting/filtering for a Sec. number (ex.195) and any cable that travels through Sec 195 will be listed (it doesn't matter if 195 is the 1st, 9th, or last section that the cable travels through) along with its material, size, PPH, and cable area. There may be up to 16 different sec. numbers that each cable travels through, so the same cable description and data will likely show when different sec. numbers are filtered for.

I have hard entered data in a format in which would like the pivot table to look like, in order to provide a visual of an end product. (Seen in attached excel file)


I have been able to create a pivot table that can be filtered to show cables traveling through different sections, however I have been only able to get this to work when there is only 1 section for routing.

Your help, assistance, and/or tips would be greatly appreciated and extremely beneficial.