organise data with pivot table

I have used pivot tables before but not in this way. I have to reorganize financial product data that has the following characteristics:

First column: each fund name
Second to last column: share class designations starting with: A, A1, A2, B, B1, B2 etc

Then the data is the CUSIP which is an identifier that defines each share class within each fund. What I'm trying to do is reorganize the data vertically so all the data is displayed in two or three columns instead of 8+ having the first column the fund name as it already is, the second each share class within the corresponding fund then the third column the CUSIP identifier for each share class. I hope this is clear enough, is there a way to use excel pivot tables to do this? I have attached data that is similar to what I am working with.

Thanks,

Zach