I have a pivot table that displays results as follows:

St Louis warehouse
plant
Pittsburg warehouse

stock

Here's what I want it to look like:

St Louis warehouse
St Louis plant
Pittsburg warehouse
Pittsburg warehouse
Pittsburg stock

I have tried every way I can think of to format the table to display the
data this way and it still "hides" the repeat values. Any ideas?

Thanks!