C
capxc
We received our inventory report in a table of 5 columns by 2400 rows.
Some of our skus have 0 in quantity. And those skus with 0 quantity are
here and there in the column E. How do we manage to regroup the report so
that i have all rows that have 0 in qtty in the bottom ; and the other ones
on the top?
Here is an illustration:
SKU ITEM DESCRIPTION PRICE WAREHOUSE QUANTITY
A B C D
E
1 01555 kshnhsdidsiidkdjdjj 2.99 ohio
6
2 05478 ookjjjccjcmcxmxm 6.44 ohio
0
3 25980 oidsidsjcjcjkcjcjckg 5.99 texas
0
4 31512 psdidsjjcjkjcjcjccm 8.54 nevada
1
5 68462 oidsjjfjjskssllslslsls 6.55 texas
0
6 85463 kjiissdsisjjjckkkijkhj 9.44 oregon
4
7 85456 oidjjsllsslslpokkjkkk 3.20 florida
0
How do we manage regroup rows 1,4 & 6 together; and rows 2,3,5 &7 together?
The purpose is that we don't want to go through all the 2400 rows and
manually select all the skus that have zero(0) in quantity because we have a
lot of them.
Thanks for sharing any tought.
Sincerely,
Some of our skus have 0 in quantity. And those skus with 0 quantity are
here and there in the column E. How do we manage to regroup the report so
that i have all rows that have 0 in qtty in the bottom ; and the other ones
on the top?
Here is an illustration:
SKU ITEM DESCRIPTION PRICE WAREHOUSE QUANTITY
A B C D
E
1 01555 kshnhsdidsiidkdjdjj 2.99 ohio
6
2 05478 ookjjjccjcmcxmxm 6.44 ohio
0
3 25980 oidsidsjcjcjkcjcjckg 5.99 texas
0
4 31512 psdidsjjcjkjcjcjccm 8.54 nevada
1
5 68462 oidsjjfjjskssllslslsls 6.55 texas
0
6 85463 kjiissdsisjjjckkkijkhj 9.44 oregon
4
7 85456 oidjjsllsslslpokkjkkk 3.20 florida
0
How do we manage regroup rows 1,4 & 6 together; and rows 2,3,5 &7 together?
The purpose is that we don't want to go through all the 2400 rows and
manually select all the skus that have zero(0) in quantity because we have a
lot of them.
Thanks for sharing any tought.
Sincerely,