Q:

PivotTable Nested Columns

I am interested in grouping columns together by a common factor. Below is a basic example:  

I'm interested in nesting the vehicle brands under the categories Luxury and Frugal. Thus making them collapsible like the rows can be. This is a basic example whereas the data I'm planning to work with this has thousands of rows of data similar to a layout as these rows and possibly 50-100 columns that could be collapsible into 5-10. Any guidance would be appreciated.

A:

As has been suggested, adding Luxury/Frugal as a column in your source data would achieve what you require. However that would require substantial rearrangement, make your source data occupy a much larger range and not give an ideal result because adding just the one column, while allowing filtering by column in the PivotTable, each filter view would still show all columns (though mostly blank).  
So completely "flattening" the source data may be a better choice, if to rearrange the source data at all:  
 
The fields arranged like so:  

