Hi,
An Excel workbook contain historical data. Each row contains year, product name, and sales for one invoice
I want to create a separate sheet with this format, where xxxx is the sum of sales in all invoices for given product and year.
2009 2010 2011
Product1 xxxx xxxx xxxx
Product2 xxxx xxxx xxxx
Product3 xxxx xxxx xxxx
Does anyone know how to do this right in the Excel workbook?
TIA,
Alex