PivotTable with Columnar data source

[Nekto]

Hey guys, this could be a really dumb dumb dumb question, but it's better to ask than not to.

I have a data source with a Column A for Customer Name, Column B for Customer Geography, and Column C for whether the info is # of Units Sold, ASP, or Total Revenue.

I also have all this Units/ASP/Revenue info spread to the right in 15 different COLUMNS, each column being its own quarter (Q1, Q2, Q3, etc.). So this all shows # of Units/ASP/Revenue by each quarter and each customer, etc.

So the question is: can I build a Pivot Table with the Q1/Q2/Q3 being its own separate filter? Or will I have to put all this Q-related info into 1 column (not 15), i.e. increase my current # of rows by 15 (Q1-Cust A-Geograph-Units, Q1-Cust A-Geograph-ASP, Q1-Cust A-Geograph-Revenue, and so forth until I create Q2-Cust A-so on).


I basically want the pivot to sort rows by Customer, Geography and ASP/Units/Rev, and keep the Quarterly info spread to the right with the respective info.

Thanks!

Nekto.

 

[Nekto]

Please let me know if you want me to add an excel file for reference.

Thanks guys!!