software

Looks like this;

A B C D E F g H
50000 valve 50120 ring 50118 nut 50113 washer
50001 bolt
50002 leg
50110 spacer
50113 washer
50116 oin
50118 nut
50120 ring
Needs to look like this;
A | B | C | D E F G
H
50000 | valve | |
50002 | leg | |
50110 | spacer | |
50113 | washer | 50113 | washer
50116 | oin | 50118 | nut
50118 | nut | 50120 | ring
50120 | ring | |

I have 440 rows and 96 colums to sort . HHHHEEELLLLPPPP!
Thanks
meagain

I may suggest one approach, that I don't know if it will fit you. The
premise is that all the numbers and words related as always the same (50120
is always a ring, not anything else).
With that, I would copy the columns A:B to a new sheet, and on column C on
that new sheet I would do a formula like:
=COUNTIF(original!$C$1:$DD$440,A1)
You may need to change the quot;originalquot; range to fit your exact case. With
that you will have for each code the number of times that it is repeated on
the matrix. Now for creating the columns you can craft simple quot;IFquot;
statements in the new sheet, for example in columns D, E, F, G:
=IF($C1=2,A1,quot;quot;)
=IF($C1=2,A2,quot;quot;)
=IF($C1=3,A2,quot;quot;)
=IF($C1=3,A2,quot;quot;)
Repeating the formula as needed.

Hope this helps,
Miguel.

quot;oldguywithbadeyesquot; wrote:

gt; Looks like this;
gt;
gt; A B C D E F g H
gt; 50000 valve 50120 ring 50118 nut 50113 washer
gt; 50001 bolt
gt; 50002 leg
gt; 50110 spacer
gt; 50113 washer
gt; 50116 oin
gt; 50118 nut
gt; 50120 ring
gt; Needs to look like this;
gt; A | B | C | D E F G
gt; H
gt; 50000 | valve | |
gt; 50002 | leg | |
gt; 50110 | spacer | |
gt; 50113 | washer | 50113 | washer
gt; 50116 | oin | 50118 | nut
gt; 50118 | nut | 50120 | ring
gt; 50120 | ring | |
gt;
gt; I have 440 rows and 96 colums to sort . HHHHEEELLLLPPPP!
gt; Thanks
gt; meagain

Sorry Miguel,
Guess i'm not smart enough to figure it out,
--
meagainquot;Miguel Zapicoquot; wrote:

gt; I may suggest one approach, that I don't know if it will fit you. The
gt; premise is that all the numbers and words related as always the same (50120
gt; is always a ring, not anything else).
gt; With that, I would copy the columns A:B to a new sheet, and on column C on
gt; that new sheet I would do a formula like:
gt; =COUNTIF(original!$C$1:$DD$440,A1)
gt; You may need to change the quot;originalquot; range to fit your exact case. With
gt; that you will have for each code the number of times that it is repeated on
gt; the matrix. Now for creating the columns you can craft simple quot;IFquot;
gt; statements in the new sheet, for example in columns D, E, F, G:
gt; =IF($C1=2,A1,quot;quot;)
gt; =IF($C1=2,A2,quot;quot;)
gt; =IF($C1=3,A2,quot;quot;)
gt; =IF($C1=3,A2,quot;quot;)
gt; Repeating the formula as needed.
gt;
gt; Hope this helps,
gt; Miguel.
gt;
gt; quot;oldguywithbadeyesquot; wrote:
gt;
gt; gt; Looks like this;
gt; gt;
gt; gt; A B C D E F g H
gt; gt; 50000 valve 50120 ring 50118 nut 50113 washer
gt; gt; 50001 bolt
gt; gt; 50002 leg
gt; gt; 50110 spacer
gt; gt; 50113 washer
gt; gt; 50116 oin
gt; gt; 50118 nut
gt; gt; 50120 ring
gt; gt; Needs to look like this;
gt; gt; A | B | C | D E F G
gt; gt; H
gt; gt; 50000 | valve | |
gt; gt; 50002 | leg | |
gt; gt; 50110 | spacer | |
gt; gt; 50113 | washer | 50113 | washer
gt; gt; 50116 | oin | 50118 | nut
gt; gt; 50118 | nut | 50120 | ring
gt; gt; 50120 | ring | |
gt; gt;
gt; gt; I have 440 rows and 96 colums to sort . HHHHEEELLLLPPPP!
gt; gt; Thanks
gt; gt; meagain

Well, forgeting about the formulas used, the idea is count the number of
times that each number appears on the area that you have to sort, and based
on that and the master column, generate the information instead of moving it.
The operations that I choose we
1. Copy the master columns (A and B) to other place
2. Use a formula to count the appearance of each code (the COUNTIF formula)
3. Use some formulas to recreate the data (the IF formulas)

The formulas support this approach, but it may not be the unique one. I
cannot think on other simpler, sorry.

Miguel.

quot;oldguywithbadeyesquot; wrote:

gt; Sorry Miguel,
gt; Guess i'm not smart enough to figure it out,
gt; --
gt; meagain
gt;
gt;
gt; quot;Miguel Zapicoquot; wrote:
gt;
gt; gt; I may suggest one approach, that I don't know if it will fit you. The
gt; gt; premise is that all the numbers and words related as always the same (50120
gt; gt; is always a ring, not anything else).
gt; gt; With that, I would copy the columns A:B to a new sheet, and on column C on
gt; gt; that new sheet I would do a formula like:
gt; gt; =COUNTIF(original!$C$1:$DD$440,A1)
gt; gt; You may need to change the quot;originalquot; range to fit your exact case. With
gt; gt; that you will have for each code the number of times that it is repeated on
gt; gt; the matrix. Now for creating the columns you can craft simple quot;IFquot;
gt; gt; statements in the new sheet, for example in columns D, E, F, G:
gt; gt; =IF($C1=2,A1,quot;quot;)
gt; gt; =IF($C1=2,A2,quot;quot;)
gt; gt; =IF($C1=3,A2,quot;quot;)
gt; gt; =IF($C1=3,A2,quot;quot;)
gt; gt; Repeating the formula as needed.
gt; gt;
gt; gt; Hope this helps,
gt; gt; Miguel.
gt; gt;
gt; gt; quot;oldguywithbadeyesquot; wrote:
gt; gt;
gt; gt; gt; Looks like this;
gt; gt; gt;
gt; gt; gt; A B C D E F g H
gt; gt; gt; 50000 valve 50120 ring 50118 nut 50113 washer
gt; gt; gt; 50001 bolt
gt; gt; gt; 50002 leg
gt; gt; gt; 50110 spacer
gt; gt; gt; 50113 washer
gt; gt; gt; 50116 oin
gt; gt; gt; 50118 nut
gt; gt; gt; 50120 ring
gt; gt; gt; Needs to look like this;
gt; gt; gt; A | B | C | D E F G
gt; gt; gt; H
gt; gt; gt; 50000 | valve | |
gt; gt; gt; 50002 | leg | |
gt; gt; gt; 50110 | spacer | |
gt; gt; gt; 50113 | washer | 50113 | washer
gt; gt; gt; 50116 | oin | 50118 | nut
gt; gt; gt; 50118 | nut | 50120 | ring
gt; gt; gt; 50120 | ring | |
gt; gt; gt;
gt; gt; gt; I have 440 rows and 96 colums to sort . HHHHEEELLLLPPPP!
gt; gt; gt; Thanks
gt; gt; gt; meagain