I have 15 products in Column A with data for each product by specific date in Columns B - AHN. Row 1 contains the dates, Row 2 contains the corresponding quarters, with Rows 3 - 17 containing the data for the Products:
A B C D ... AHN
1 2/26/01 3/23/01 4/12/01 ... 12/10/17
2 1Q2001 1Q2001 2Q2001 ... 4Q2017
3 Glasses 0 300 0 ... 0
...
17 Dresses 0 0 500 ... 2000
There are days with no data on any product, so Column B is 2/2/01 and Column E is 3/23/01 (Nothing happened between Feb 3 and March 22). And not all products have sales on the same day or even same month, so Product A (Glasss) will have data in Cell D3, but other products have no data for that date.). I want to show sales by quarter for each of the 15 products, with Column B being 1Q2001, Column C being 2Q2001, etc. and Row 3 as Product #1 , Row 4 being Product #2 , all the way to Product 15 in Row 18Is there a way to do this with Pivot Tables? If not, how? I would prefer not to use VBA since I mainly use a Mac
A B C D ... AHN
1 2/26/01 3/23/01 4/12/01 ... 12/10/17
2 1Q2001 1Q2001 2Q2001 ... 4Q2017
3 Glasses 0 300 0 ... 0
...
17 Dresses 0 0 500 ... 2000
There are days with no data on any product, so Column B is 2/2/01 and Column E is 3/23/01 (Nothing happened between Feb 3 and March 22). And not all products have sales on the same day or even same month, so Product A (Glasss) will have data in Cell D3, but other products have no data for that date.). I want to show sales by quarter for each of the 15 products, with Column B being 1Q2001, Column C being 2Q2001, etc. and Row 3 as Product #1 , Row 4 being Product #2 , all the way to Product 15 in Row 18Is there a way to do this with Pivot Tables? If not, how? I would prefer not to use VBA since I mainly use a Mac
