AnsweredAssumed Answered

Select Records in sequence from sorted file

Question asked by Powerbook on Feb 22, 2018
Latest reply on Feb 23, 2018 by Powerbook

I'm in brain lock.....

I have the following table:

 

Category 1

          Tool 1

               Record 1

               Record 2

               Record 3

               Record 4

               Record 5

               Record 6

Category 2

          Tool 2

               Record 7

               Record 8

               Record 9

               Record 10

 

 

I need to create create a table that looks like this:

 

Category 1

               Tool1

                    Record 1

               Tool 2

                    Record 7

               Tool 1

                    Record 2

               Tool 2

                     Record 8

               Tool 1

                    Record 3

               Tool 2

                     Record 9

               Tool 1

                     Record 4

               Tool 2

                     Record 10

               Tool 1

                     Record 5

               Tool 1

                     Record 6

 

                   

 

and go on with all the other Categories until the end.

"Tool 1 or 2 " do not have the same amount of records.

 

Can anybody help me?

Thank you in advance.

Outcomes