Hello everyone, I have the data table below:
I would like to use the divide function, put the weeks in columns (“week”), the types of week in lines (“analysis column”) and in the cells the different types of object (“TYPE”).
The problem is that when I use the split function, JMP only enters the cell the last "TYPE" corresponding to the week and the week type as below it should however fill in all the different "TYPE" corresponding:
Here in the cell under "Week 22" we should see "A,B,C,D,E and F"
Here in the cell under "Week 23" we should see "G,H,I,J and K"
How could I get around this problem?
Thanks for your help !
