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; } } }

869911_en-US

liliconcom

how do I change the format of the table -

Hi colleagues,

I am just starting and want your help

How do I convert the following format of my data table to the one I can analyze? Thanks so much

My table looks like this

subject	time	variable	value
1	b	A	2
1	wk2	A	5
1	wk6	A	6
1	b	B	1
1	wk2	B	1.5
1	wk6	B	3
2	b	A	5
2	wk2	A	6
2	wk6	A	4
2	b	B	7
2	wk2	B	8
2	wk6	B	9

I want to convert to the following format

subject	time	A	B
1	b	2	1
1	wk2	5	1.5
1	wk6	6	3
2	b	5	7
2	wk2	6	8
2	wk6	4	9

Content Organization

Re: how do I change the format of the table -

Welcome t the Community.

You just have to use

Tables=>Split

Re: how do I change the format of the table -

Hi @Bio2025,

If you haven't done so, I'd recommend you try out the Getting Started Webinar to look at how to use JMP and JMP interfaces. I'd also recommend this video on splitting and stacking data - its a function you'll end up using a lot in JMP so it's well worth knowing! There's an article series too on it.