How to regroup rows that have the same value in a particular colum
 

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,
--
capxc

How to regroup rows that have the same value in a particular colum
 

Select cols A to E, then do a Data Sort Sort by: Quantity (descending) OK
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,000 Files:354 Subscribers:53
xdemechanik
---
"capxc" wrote:
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,
--
capxc

Here is a clean version of the illustration.
 

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 DESC PRC WRH QTY
A B C D E
1 01555 kshn 2.99 OH 6
2 05478 ookj 6.44 OH 0
3 25980 oidsi 5.99 TX 0
4 31512 psdi 8.54 NV 1
5 68462 oids 6.55 TX 0
6 85463 kjiis 9.44 OR 4
7 85456 oidjj 3.20 FL 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,
--
capxc

--
capxc


"capxc" wrote:

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,
--
capxc

How to regroup rows that have the same value in a particular c
 

Thank You Max.
Sincerely,
--
capxc


"Max" wrote:

Select cols A to E, then do a Data Sort Sort by: Quantity (descending) OK
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,000 Files:354 Subscribers:53
xdemechanik
---
"capxc" wrote:
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,
--
capxc

How to regroup rows that have the same value in a particular c
 

Welcome. Pl press the "Yes" button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,000 Files:354 Subscribers:53
xdemechanik
---
"capxc" wrote:
Thank You Max.
Sincerely,
--
capxc