How to stack as a matrix? Or some other function to achieve this?

[#1]

Hi, I am new to JMP. I have a chellenge while scripting to stack values as shown in the first table below to the values in the second table. How can I arrage this?

date	SP_top	SP_Bottom	Coating_top	Coating_bottom	Reading_top	Reading_bottom
D1	S1	S2	C1	C2	R1	R2
D2	S3	S4	C3	C4	R3	R4

date	location	SP	Coating	Reading
D1	Top	S1	C1	R1
D1	Bottom	S2	C2	R2
D2	Top	S3	C3	R3
D2	Bottom	S4	C4	R4

[#2 · Accepted solution]

First stack with something like this

jthi_0-1686770546810.png

next split the label column to two using text to columns

jthi_1-1686770576875.png

jthi_2-1686770590494.png

then recode issues in Label 2 (some are Bottom and some bottom) by grouping them

then you can split this

jthi_3-1686770716950.png

into this

jthi_4-1686770725805.png

If you have JMP16+ I think these steps will be captured by enhanced log (or workflow if JMP17 and you wish to create one)

jthi_5-1686770806094.png

[#3]

Awesome. Your solution gives exatly what I wanted. Thank you so much!