I have a table of sales transactions that I need to convert to a list.
The file is attached. Each Row represents a specific date. The first three columns are Date, Salesperson and Location. Then there are three more columns for each of the five products being sold. Each product has a Quantity, Price and Value Column.
I'd like instead an output that gives me
Date Salesperson Location Product Quantity Price Value
The descriptions I've found on the web are either in VBA - that doesn't match up correctly or describe a set of menu options from Excel 2007 that I can't find (I'm using 2010).
It feels like I should be able to do this with a pivot table, but I can't figure out how.
Thank you!
Vikas
The file is attached. Each Row represents a specific date. The first three columns are Date, Salesperson and Location. Then there are three more columns for each of the five products being sold. Each product has a Quantity, Price and Value Column.
I'd like instead an output that gives me
Date Salesperson Location Product Quantity Price Value
The descriptions I've found on the web are either in VBA - that doesn't match up correctly or describe a set of menu options from Excel 2007 that I can't find (I'm using 2010).
It feels like I should be able to do this with a pivot table, but I can't figure out how.
Thank you!
Vikas