Generate list
 

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.

Generate list
 

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
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"dvya" wrote:

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.

Generate list
 

Use a 2-D Pivot Table. See:

http://pubs.logicalexpressions.com/P...cle.asp?ID=553

for an example similar to your needs.
--
Gary''s Student - gsnu200796

Generate list
 

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

"M Kan" wrote:

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
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"dvya" wrote:

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.