Need Excel pivot table independent columns and no sub levels

Experts: Need an help - i want the excel pivot table to show each logically independent columns next to each other instead of sub level/nested.

I can surely create multiple pivot table but would be ending up having 10+. So is it possible and if yes how? I tried Google and looking through videos but they were of no help, so I'm finally writing a post.

This is how I want it to look:

Added a sample sheet and the pivot table that i get and how i want it to be :)


I believe you are looking for the report layout settings.Choose something other than "Compact" and you should meet your goal. "No sub-levels" can be obtained by clicking Subtotals and Grand Totals to the left of Report Layout report layout