Need formula or report to condense table, not by manual sort
I am trying to find a formula or other way (other than manually sort) to
select from the table below, just the list of items that have a quantity.
Basically create a table in another sheet using the data below but
€ścondensed€ť without adding the items that have no quantity values. The table
is lengthy and I want to create a formula or report. I know sorting would
give me the view I need want a formula to do automatically and not show any
items that are €śzero€ť.
Thanks.
A B
1 Item description Item Qty
2 AirConditioner Large
3 AirConditioner Small
4 Baby Carriage 1
5 Baby Crib
6 Base Buffet 2
7 Bathinette
8 BBQ Grill Large
9 BBQ Grill Small 1
10 Bed, Bunk (Set of 2)
11 Bed, King
12 Bed, Queen 1
13 Bed, Rollaway
14 Bed, Single/Hollywood
15 Bed, Standard Double
16 Bed, Waterbed Base
17 Bed, Youth
18 Bicycle
Desired result:
1 Baby Carriage
2 Base Buffet
1 BBQ Grill Small
1 Bed, Queen
|