Generate list

[dvya]

Im trying to simplify shopping lists in my home. I have a basic list that we
can complete weekly. how can i generate from this a list that will only
include items and stores that have to be shopped at? I am primarily looking
for a list that the column headers will be source and the row headers just
the items that have a value in the quantity column with the quantity showing
under the proper column.

So that a list that starts like this:

Item Source Quantity
Alaskan Salmon Trader Joes
Almond Milk Whole Foods 1
Apple Cider Smart & Final 3
Apple Juice Smart & Final 7
Apples Ralphs


will generate a list that looks like this:

Whole Foods Smart & Final
Almond Milk 1
Apple Cider 3
Apple Juice 7



Thank you.

 

[M Kan]

You could just generate a pivot table with items listed in the Row, stores
listed in the Column, and acount of items listed in the Data Field

 

[Gary''s Student]

Use a 2-D Pivot Table. See:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=553

for an example similar to your needs.

 

[dvya]

how do i get it to hide the rows that dont have any data? im using excel
2007. Thank you.