nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do I index repeated values on Table when values are nested?

Hi All,
 
I have a table in JMP such as:
ItemNum
Level
Result
Item1
A
98x
Item1
B
23x
Item1
C
47x
Item1
C
13x
Item1
A
22x
Item1
B
12x
Item1
A
18x
Item1
B
2x
Item1
C
50x
item2
A
80x
item2
B
34x
item2
C
70x
item2
C
51x
item2
A
65x
item2
B
5x
item2
A
100x
item2
B
79x
item2
C
67x
 
I would like to transpose it into.
ItemNum
A
B
C
Item1
98x
23x
47x
Item1
22x
12x
13x
Item1
18x
2x
50x
item2
80x
34x
70x
item2
65x
5x
51x
item2
100x
79x
67x
 However, the JMP transpose platform produces this:
 
ItemNum
Label
A
B
C
Item1
Result
18x
2x
50x
item2
Result
100x
79x
67x
 
How could I get the transpose platform to take into account that item1 and item2 repeat more than one time?
 
Thank you
 
 

Accepted answers

Thank you!

All comments

txnelson

Use

Tables==>Split

and setup the dialog box like:

Which gives the resulting data table

Thank you!