Help Organizing data for use in a Pivot Table

Perhaps using the Grouping feature would achieve what you want.
In the attached file selecting the number 1 in the top left corner of the sheet (not the header for row 1) will display only the Top Level Part#
Selecting the number 2 will also display the part #'s stored in Station 3
Selecting the number 3 will also display the part #'s stored in Station 2
Selecting the number 4 will also display the part #'s stored in Station 1
Let us know if you have any questions.