AnsweredAssumed Answered

IMPORTING AND GROUPING A NUMBER LIST FROM ANOTHER TABLE

Question asked by khank on Nov 2, 2010
Latest reply on Nov 2, 2010 by philmodjunk

Title

IMPORTING AND GROUPING A NUMBER LIST FROM ANOTHER TABLE

Post

This is probably a "scripting" issue and I have no clue about scripting. 

I have a number list ranging from 1 through 10, including the number of times it was ordered (1:12), on table titled TenOrig. 

What I'm trying to do is group particular numbers together on another table titled GroupNums. 

TenOrig list example:

1 : 12 

2 : 13

3 : 12

4 : 13

5 : 13

6 : 16

7 : 16

8 : 12

9 : 16

10 : 16

In the "GroupNums" table I want to group 1, 3, 8, then 2, 4, 5 and finally 6, 7, 9, 10.

GroupNums list example:

1 : 12

3 : 12

8 : 12

2 : 13

4 : 13

5 : 13

6 : 16

7 : 16

9 : 16

10 : 16

You'll notice I've included a "space" between the groupings – is that possible?

Outcomes