Pivot table only duplicate show, help required

[Umqub1]

have two lists
List1 = (1,2,3,4,5,6,7,8,9)
List 2 = (a, b, c, d, e, f, g, h, c)
Here c have 2 corresponding entries in list 1 which are 3 and 9
I want to use pivot table to only show c in row and 3 and 9 in columns field
While the rest of the others i want to skip
How can I do that?
Please help

[JeteMc]

Welcome to Excel Forum.
If I am understanding correctly, you want to place both List 1 and List 2 in the column labels field of the pivot table, however you want only those numbers from List 1 that correspond to the value c from List 2 to be shown. If that is the case you can apply a label filter to the column heading List 2 so that only items that begin with c are shown. The attached file shows a pivot table with that filter applied.
Let us know if you have any questions.