Ok, I figured it out. With the pivot table selected, go to the top right section and it has a heading for Pivot Table Tools. Select Design, select Report Layout and then Show in Tabular Form. You might have had yours already set to default it like this.

Thanks, this works beautifully and once I finish setting it up will save a huge amount of time.