That is the point. To make a pivot table, you need the data expanded out. This "expanded out" is the same as what you get when you "show all". What I think you are really looking for is a filter of the original data to get the format you need.

Look at AutoFilter for your data and see if that is more of what you need.