<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: how do I change the format of the table - in Discussions</title>
    <link>https://community.jmp.com/t5/Discussions/how-do-I-change-the-format-of-the-table/m-p/869922#M103295</link>
    <description>&lt;P&gt;Welcome t the Community.&lt;/P&gt;
&lt;P&gt;You just have to use&lt;/P&gt;
&lt;P&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;Tables=&amp;gt;Split&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="txnelson_0-1745448721547.png" style="width: 774px;"&gt;&lt;img src="https://community.jmp.com/t5/image/serverpage/image-id/75139i41EE8080FBC5EDA7/image-dimensions/774x383?v=v2" width="774" height="383" role="button" title="txnelson_0-1745448721547.png" alt="txnelson_0-1745448721547.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Wed, 23 Apr 2025 22:52:21 GMT</pubDate>
    <dc:creator>txnelson</dc:creator>
    <dc:date>2025-04-23T22:52:21Z</dc:date>
    <item>
      <title>how do I change the format of the table -</title>
      <link>https://community.jmp.com/t5/Discussions/how-do-I-change-the-format-of-the-table/m-p/869911#M103294</link>
      <description>&lt;P&gt;Hi colleagues,&lt;/P&gt;
&lt;P&gt;I am just starting and want your help&lt;/P&gt;
&lt;P&gt;How do I convert the following format of my data table to the one I can analyze?&amp;nbsp; Thanks so much&amp;nbsp;&lt;/P&gt;
&lt;P&gt;My table looks like this&lt;/P&gt;
&lt;TABLE style="border-collapse: collapse; width: 192pt;" border="0" width="256" cellspacing="0" cellpadding="0"&gt;&lt;COLGROUP&gt;&lt;COL style="width: 48pt;" span="4" width="64" /&gt; &lt;/COLGROUP&gt;
&lt;TBODY&gt;
&lt;TR style="height: 14.4pt;"&gt;
&lt;TD width="64" height="19" style="height: 14.4pt; width: 48pt;"&gt;subject&lt;/TD&gt;
&lt;TD width="64" style="width: 48pt;"&gt;time&lt;/TD&gt;
&lt;TD width="64" style="width: 48pt;"&gt;variable&lt;/TD&gt;
&lt;TD width="64" style="width: 48pt;"&gt;value&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 14.4pt;"&gt;
&lt;TD height="19" align="right" style="height: 14.4pt;"&gt;1&lt;/TD&gt;
&lt;TD&gt;b&lt;/TD&gt;
&lt;TD&gt;A&lt;/TD&gt;
&lt;TD align="right"&gt;2&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 14.4pt;"&gt;
&lt;TD height="19" align="right" style="height: 14.4pt;"&gt;1&lt;/TD&gt;
&lt;TD&gt;wk2&lt;/TD&gt;
&lt;TD&gt;A&lt;/TD&gt;
&lt;TD align="right"&gt;5&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 14.4pt;"&gt;
&lt;TD height="19" align="right" style="height: 14.4pt;"&gt;1&lt;/TD&gt;
&lt;TD&gt;wk6&lt;/TD&gt;
&lt;TD&gt;A&lt;/TD&gt;
&lt;TD align="right"&gt;6&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 14.4pt;"&gt;
&lt;TD height="19" align="right" style="height: 14.4pt;"&gt;1&lt;/TD&gt;
&lt;TD&gt;b&lt;/TD&gt;
&lt;TD&gt;B&lt;/TD&gt;
&lt;TD align="right"&gt;1&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 14.4pt;"&gt;
&lt;TD height="19" align="right" style="height: 14.4pt;"&gt;1&lt;/TD&gt;
&lt;TD&gt;wk2&lt;/TD&gt;
&lt;TD&gt;B&lt;/TD&gt;
&lt;TD align="right"&gt;1.5&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 14.4pt;"&gt;
&lt;TD height="19" align="right" style="height: 14.4pt;"&gt;1&lt;/TD&gt;
&lt;TD&gt;wk6&lt;/TD&gt;
&lt;TD&gt;B&lt;/TD&gt;
&lt;TD align="right"&gt;3&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 14.4pt;"&gt;
&lt;TD height="19" align="right" style="height: 14.4pt;"&gt;2&lt;/TD&gt;
&lt;TD&gt;b&lt;/TD&gt;
&lt;TD&gt;A&lt;/TD&gt;
&lt;TD align="right"&gt;5&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 14.4pt;"&gt;
&lt;TD height="19" align="right" style="height: 14.4pt;"&gt;2&lt;/TD&gt;
&lt;TD&gt;wk2&lt;/TD&gt;
&lt;TD&gt;A&lt;/TD&gt;
&lt;TD align="right"&gt;6&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 14.4pt;"&gt;
&lt;TD height="19" align="right" style="height: 14.4pt;"&gt;2&lt;/TD&gt;
&lt;TD&gt;wk6&lt;/TD&gt;
&lt;TD&gt;A&lt;/TD&gt;
&lt;TD align="right"&gt;4&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 14.4pt;"&gt;
&lt;TD height="19" align="right" style="height: 14.4pt;"&gt;2&lt;/TD&gt;
&lt;TD&gt;b&lt;/TD&gt;
&lt;TD&gt;B&lt;/TD&gt;
&lt;TD align="right"&gt;7&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 14.4pt;"&gt;
&lt;TD height="19" align="right" style="height: 14.4pt;"&gt;2&lt;/TD&gt;
&lt;TD&gt;wk2&lt;/TD&gt;
&lt;TD&gt;B&lt;/TD&gt;
&lt;TD align="right"&gt;8&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 14.4pt;"&gt;
&lt;TD height="19" align="right" style="height: 14.4pt;"&gt;2&lt;/TD&gt;
&lt;TD&gt;wk6&lt;/TD&gt;
&lt;TD&gt;B&lt;/TD&gt;
&lt;TD align="right"&gt;9&lt;/TD&gt;
&lt;/TR&gt;
&lt;/TBODY&gt;
&lt;/TABLE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;I want to convert to the following format&lt;/P&gt;
&lt;TABLE style="border-collapse: collapse; width: 192pt;" border="0" width="256" cellspacing="0" cellpadding="0"&gt;&lt;COLGROUP&gt;&lt;COL style="width: 48pt;" span="4" width="64" /&gt; &lt;/COLGROUP&gt;
&lt;TBODY&gt;
&lt;TR style="height: 14.4pt;"&gt;
&lt;TD width="64" height="19" style="height: 14.4pt; width: 48pt;"&gt;subject&lt;/TD&gt;
&lt;TD width="64" style="width: 48pt;"&gt;time&lt;/TD&gt;
&lt;TD width="64" style="width: 48pt;"&gt;A&lt;/TD&gt;
&lt;TD width="64" style="width: 48pt;"&gt;B&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 14.4pt;"&gt;
&lt;TD height="19" align="right" style="height: 14.4pt;"&gt;1&lt;/TD&gt;
&lt;TD&gt;b&lt;/TD&gt;
&lt;TD align="right"&gt;2&lt;/TD&gt;
&lt;TD align="right"&gt;1&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 14.4pt;"&gt;
&lt;TD height="19" align="right" style="height: 14.4pt;"&gt;1&lt;/TD&gt;
&lt;TD&gt;wk2&lt;/TD&gt;
&lt;TD align="right"&gt;5&lt;/TD&gt;
&lt;TD align="right"&gt;1.5&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 14.4pt;"&gt;
&lt;TD height="19" align="right" style="height: 14.4pt;"&gt;1&lt;/TD&gt;
&lt;TD&gt;wk6&lt;/TD&gt;
&lt;TD align="right"&gt;6&lt;/TD&gt;
&lt;TD align="right"&gt;3&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 14.4pt;"&gt;
&lt;TD height="19" align="right" style="height: 14.4pt;"&gt;2&lt;/TD&gt;
&lt;TD&gt;b&lt;/TD&gt;
&lt;TD align="right"&gt;5&lt;/TD&gt;
&lt;TD align="right"&gt;7&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 14.4pt;"&gt;
&lt;TD height="19" align="right" style="height: 14.4pt;"&gt;2&lt;/TD&gt;
&lt;TD&gt;wk2&lt;/TD&gt;
&lt;TD align="right"&gt;6&lt;/TD&gt;
&lt;TD align="right"&gt;8&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR style="height: 14.4pt;"&gt;
&lt;TD height="19" align="right" style="height: 14.4pt;"&gt;2&lt;/TD&gt;
&lt;TD&gt;wk6&lt;/TD&gt;
&lt;TD align="right"&gt;4&lt;/TD&gt;
&lt;TD align="right"&gt;9&lt;/TD&gt;
&lt;/TR&gt;
&lt;/TBODY&gt;
&lt;/TABLE&gt;</description>
      <pubDate>Wed, 23 Apr 2025 22:45:00 GMT</pubDate>
      <guid>https://community.jmp.com/t5/Discussions/how-do-I-change-the-format-of-the-table/m-p/869911#M103294</guid>
      <dc:creator>Bio2025</dc:creator>
      <dc:date>2025-04-23T22:45:00Z</dc:date>
    </item>
    <item>
      <title>Re: how do I change the format of the table -</title>
      <link>https://community.jmp.com/t5/Discussions/how-do-I-change-the-format-of-the-table/m-p/869922#M103295</link>
      <description>&lt;P&gt;Welcome t the Community.&lt;/P&gt;
&lt;P&gt;You just have to use&lt;/P&gt;
&lt;P&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;Tables=&amp;gt;Split&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="txnelson_0-1745448721547.png" style="width: 774px;"&gt;&lt;img src="https://community.jmp.com/t5/image/serverpage/image-id/75139i41EE8080FBC5EDA7/image-dimensions/774x383?v=v2" width="774" height="383" role="button" title="txnelson_0-1745448721547.png" alt="txnelson_0-1745448721547.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 23 Apr 2025 22:52:21 GMT</pubDate>
      <guid>https://community.jmp.com/t5/Discussions/how-do-I-change-the-format-of-the-table/m-p/869922#M103295</guid>
      <dc:creator>txnelson</dc:creator>
      <dc:date>2025-04-23T22:52:21Z</dc:date>
    </item>
    <item>
      <title>Re: how do I change the format of the table -</title>
      <link>https://community.jmp.com/t5/Discussions/how-do-I-change-the-format-of-the-table/m-p/869981#M103300</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;a href="https://community.jmp.com/t5/user/viewprofilepage/user-id/68000"&gt;@Bio2025&lt;/a&gt;,&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;If you haven't done so, I'd recommend you try out the &lt;A href="https://community.jmp.com/t5/Getting-Started-with-JMP/Getting-Started-with-JMP-On-Demand-Course/ta-p/621172" target="_self"&gt;Getting Started Webinar&lt;/A&gt; to look at how to use JMP and JMP interfaces. I'd also recommend &lt;A href="https://community.jmp.com/t5/Statistical-Thinking-for/Stacking-and-Splitting-Data/ta-p/271846" target="_self"&gt;this video on splitting and stacking data&amp;nbsp;&lt;/A&gt;- its a function you'll end up using a lot in JMP so it's well worth knowing! There's an&lt;A href="https://community.jmp.com/t5/JMPer-Cable/Manipulating-Data-in-JMP-Using-Tables-gt-Split/ba-p/41363" target="_self"&gt; article series&lt;/A&gt; too on it.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Thanks,&lt;/P&gt;
&lt;P&gt;Ben&lt;/P&gt;</description>
      <pubDate>Thu, 24 Apr 2025 08:13:28 GMT</pubDate>
      <guid>https://community.jmp.com/t5/Discussions/how-do-I-change-the-format-of-the-table/m-p/869981#M103300</guid>
      <dc:creator>Ben_BarrIngh</dc:creator>
      <dc:date>2025-04-24T08:13:28Z</dc:date>
    </item>
  </channel>
</rss>

