{"id":4915,"date":"2025-05-22T09:05:46","date_gmt":"2025-05-22T07:05:46","guid":{"rendered":"https:\/\/www.psyctc.org\/psyctc\/?post_type=docs&#038;p=4915"},"modified":"2025-05-22T09:05:47","modified_gmt":"2025-05-22T07:05:47","password":"","slug":"long-thin-format-data","status":"publish","type":"docs","link":"https:\/\/www.psyctc.org\/psyctc\/glossary2\/long-thin-format-data\/","title":{"rendered":"Long (&#8220;thin&#8221;) format data"},"content":{"rendered":"\n<p>Is what it says!  A dataset that is long and thin!<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Details<\/h4>\n\n\n\n<p>So what?  Well, often in our fields we have repeated, nested data, e.g. multiple completions of measures by the same person over time.  You can arrange this in some database or statistical computer package like this:<\/p>\n\n\n\n<div class=\"wpdt-c wdt-skin-light\">\n    \n    <input type=\"hidden\" id=\"wdtNonceFrontendServerSide_36\" name=\"wdtNonceFrontendServerSide_36\" value=\"72be2929a1\" \/><input type=\"hidden\" name=\"_wp_http_referer\" value=\"\/psyctc\/wp-json\/wp\/v2\/docs\/4915\" \/>    <input type=\"hidden\" id=\"table_1_desc\"\n           value='{\"tableId\":\"table_1\",\"tableType\":\"manual\",\"selector\":\"#table_1\",\"responsive\":false,\"responsiveAction\":\"icon\",\"editable\":false,\"inlineEditing\":false,\"infoBlock\":false,\"pagination_top\":0,\"pagination\":0,\"paginationAlign\":\"right\",\"paginationLayout\":\"full_numbers\",\"paginationLayoutMobile\":\"simple\",\"file_location\":\"\",\"tableSkin\":\"light\",\"table_wcag\":0,\"simple_template_id\":0,\"scrollable\":true,\"fixedLayout\":false,\"globalSearch\":false,\"showRowsPerPage\":false,\"popoverTools\":false,\"loader\":1,\"showCartInformation\":0,\"hideBeforeLoad\":false,\"number_format\":2,\"decimalPlaces\":2,\"spinnerSrc\":\"https:\\\/\\\/www.psyctc.org\\\/psyctc\\\/wp-content\\\/plugins\\\/wpdatatables\\\/assets\\\/\\\/img\\\/spinner.gif\",\"groupingEnabled\":false,\"tableWpId\":36,\"dataTableParams\":{\"sDom\":\"BT\\u003C\\u0027clear\\u0027\\u003E\\u003C\\u0027wdtscroll\\u0027t\\u003E\",\"bSortCellsTop\":false,\"bFilter\":true,\"aLengthMenu\":[[1,5,10,25,50,100,-1],[1,5,10,25,50,100,\"All\"]],\"iDisplayLength\":10,\"columnDefs\":[{\"sType\":\"formatted-num\",\"wdtType\":\"int\",\"bVisible\":false,\"orderable\":true,\"searchable\":true,\"InputType\":\"none\",\"name\":\"wdt_ID\",\"origHeader\":\"wdt_ID\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\"numdata integer  column-wdt_id\",\"aTargets\":[0]},{\"sType\":\"string\",\"wdtType\":\"string\",\"bVisible\":false,\"orderable\":true,\"searchable\":true,\"InputType\":\"none\",\"name\":\"wdt_created_by\",\"origHeader\":\"wdt_created_by\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\" column-wdt_created_by\",\"aTargets\":[1]},{\"sType\":\"date-custom\",\"wdtType\":\"datetime\",\"bVisible\":false,\"orderable\":true,\"searchable\":true,\"InputType\":\"datetime\",\"name\":\"wdt_created_at\",\"origHeader\":\"wdt_created_at\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\" column-wdt_created_at\",\"aTargets\":[2]},{\"sType\":\"string\",\"wdtType\":\"string\",\"bVisible\":false,\"orderable\":true,\"searchable\":true,\"InputType\":\"none\",\"name\":\"wdt_last_edited_by\",\"origHeader\":\"wdt_last_edited_by\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\" column-wdt_last_edited_by\",\"aTargets\":[3]},{\"sType\":\"date-custom\",\"wdtType\":\"datetime\",\"bVisible\":false,\"orderable\":true,\"searchable\":true,\"InputType\":\"datetime\",\"name\":\"wdt_last_edited_at\",\"origHeader\":\"wdt_last_edited_at\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\" column-wdt_last_edited_at\",\"aTargets\":[4]},{\"sType\":\"formatted-num\",\"wdtType\":\"int\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"id\",\"origHeader\":\"id\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\"numdata integer  column-id\",\"aTargets\":[5]},{\"sType\":\"formatted-num\",\"wdtType\":\"float\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"item011\",\"origHeader\":\"item011\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\"numdata float  column-item011\",\"aTargets\":[6]},{\"sType\":\"formatted-num\",\"wdtType\":\"float\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"item021\",\"origHeader\":\"item021\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\"numdata float  column-item021\",\"aTargets\":[7]},{\"sType\":\"formatted-num\",\"wdtType\":\"float\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"item031\",\"origHeader\":\"item031\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\"numdata float  column-item031\",\"aTargets\":[8]},{\"sType\":\"formatted-num\",\"wdtType\":\"float\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"item041\",\"origHeader\":\"item041\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\"numdata float  column-item041\",\"aTargets\":[9]},{\"sType\":\"formatted-num\",\"wdtType\":\"float\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"item051\",\"origHeader\":\"item051\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\"numdata float  column-item051\",\"aTargets\":[10]},{\"sType\":\"formatted-num\",\"wdtType\":\"float\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"item012\",\"origHeader\":\"item012\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\"numdata float  column-item012\",\"aTargets\":[11]},{\"sType\":\"formatted-num\",\"wdtType\":\"float\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"item022\",\"origHeader\":\"item022\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\"numdata float  column-item022\",\"aTargets\":[12]},{\"sType\":\"formatted-num\",\"wdtType\":\"float\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"item032\",\"origHeader\":\"item032\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\"numdata float  column-item032\",\"aTargets\":[13]},{\"sType\":\"formatted-num\",\"wdtType\":\"float\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"item042\",\"origHeader\":\"item042\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\"numdata float  column-item042\",\"aTargets\":[14]},{\"sType\":\"formatted-num\",\"wdtType\":\"float\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"item052\",\"origHeader\":\"item052\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\"numdata float  column-item052\",\"aTargets\":[15]}],\"bAutoWidth\":false,\"order\":[[0,\"asc\"]],\"ordering\":false,\"fixedHeader\":{\"header\":false,\"headerOffset\":0},\"fixedColumns\":false,\"oLanguage\":{\"sSearchPlaceholder\":\"\"},\"buttons\":[],\"bProcessing\":false,\"serverSide\":true,\"ajax\":{\"url\":\"https:\\\/\\\/www.psyctc.org\\\/psyctc\\\/wp-admin\\\/admin-ajax.php?action=get_wdtable&table_id=36\",\"type\":\"POST\"},\"oSearch\":{\"bSmart\":false,\"bRegex\":false,\"sSearch\":\"\"}},\"customRowDisplay\":\"\",\"tabletWidth\":\"1024\",\"mobileWidth\":\"480\",\"renderFilter\":\"footer\",\"advancedFilterEnabled\":false,\"serverSide\":true,\"autoRefreshInterval\":0,\"processing\":true,\"fnServerData\":true,\"columnsFixed\":0,\"sumFunctionsLabel\":\"\",\"avgFunctionsLabel\":\"\",\"minFunctionsLabel\":\"\",\"maxFunctionsLabel\":\"\",\"columnsDecimalPlaces\":{\"wdt_ID\":-1,\"wdt_created_by\":-1,\"wdt_created_at\":-1,\"wdt_last_edited_by\":-1,\"wdt_last_edited_at\":-1,\"id\":-1,\"item011\":-1,\"item021\":-1,\"item031\":-1,\"item041\":-1,\"item051\":-1,\"item012\":-1,\"item022\":-1,\"item032\":-1,\"item042\":-1,\"item052\":-1},\"columnsThousandsSeparator\":{\"wdt_ID\":0,\"id\":1},\"sumColumns\":[],\"avgColumns\":[],\"sumAvgColumns\":[],\"timeFormat\":\"h:i A\",\"datepickFormat\":\"dd\\\/mm\\\/yy\"}'\/>\n\n    <table id=\"table_1\"\n           class=\" scroll  display nowrap wdt-no-display data-t data-t wpDataTable wpDataTableID-36 \"\n           style=\"\"\n           data-described-by='table_1_desc'\n           data-wpdatatable_id=\"36\">\n        \n        <!-- Table header -->\n        \n<thead>\n<tr>\n                    <th\n                        class=\" wdtheader sort numdata integer \"\n        style=\"\">        wdt_ID<\/th>        <th\n                        class=\" wdtheader sort \"\n        style=\"\">        wdt_created_by<\/th>        <th\n                        class=\" wdtheader sort \"\n        style=\"\">        wdt_created_at<\/th>        <th\n                        class=\" wdtheader sort \"\n        style=\"\">        wdt_last_edited_by<\/th>        <th\n                        class=\" wdtheader sort \"\n        style=\"\">        wdt_last_edited_at<\/th>        <th\n        data-class=\"expand\"                class=\" wdtheader sort numdata integer \"\n        style=\"\">        ID<\/th>        <th\n                        class=\" wdtheader sort numdata float \"\n        style=\"\">        Item01_1<\/th>        <th\n                        class=\" wdtheader sort numdata float \"\n        style=\"\">        Item02_1<\/th>        <th\n                        class=\" wdtheader sort numdata float \"\n        style=\"\">        Item03_1<\/th>        <th\n                        class=\" wdtheader sort numdata float \"\n        style=\"\">        Item04_1<\/th>        <th\n                        class=\" wdtheader sort numdata float \"\n        style=\"\">        Item05_1<\/th>        <th\n                        class=\" wdtheader sort numdata float \"\n        style=\"\">        Item01_2<\/th>        <th\n                        class=\" wdtheader sort numdata float \"\n        style=\"\">        Item02_2<\/th>        <th\n                        class=\" wdtheader sort numdata float \"\n        style=\"\">        Item03_2<\/th>        <th\n                        class=\" wdtheader sort numdata float \"\n        style=\"\">        Item04_2<\/th>        <th\n                        class=\" wdtheader sort numdata float \"\n        style=\"\">        Item05_2<\/th>    <\/tr>\n<\/thead>\n        <!-- \/Table header -->\n\n        <!-- Table body -->\n        \n<tbody>\n<!-- Table body -->\n<div data-id=\"36\"\n     class=\"wdt-timeline-item wdt-timeline-table_1\"\n     style=\"\">\n    <div class=\"wdt-table-loader\">\n        <div class=\"wdt-table-loader-row wdt-table-loader-header\">\n            <div class=\"wdt-table-loader-header-cell wdt-animated-background\"><\/div>\n            <div class=\"wdt-table-loader-header-cell wdt-animated-background\"><\/div>\n            <div class=\"wdt-table-loader-header-cell wdt-animated-background\"><\/div>\n        <\/div>\n                    <div class=\"wdt-table-loader-row\">\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n            <\/div>\n                    <div class=\"wdt-table-loader-row\">\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n            <\/div>\n            <\/div>\n<\/div><!-- \/Table body -->\n                    <tr id=\"table_36_row_0\"\n            data-row-index=\"0\">\n                            <td style=\"\">1<\/td>\n                            <td style=\"\">chris<\/td>\n                            <td style=\"\">22\/05\/2025 08:40 AM<\/td>\n                            <td style=\"\">chris<\/td>\n                            <td style=\"\">22\/05\/2025 08:40 AM<\/td>\n                            <td style=\"\">1<\/td>\n                            <td style=\"\">0.60<\/td>\n                            <td style=\"\">-1.70<\/td>\n                            <td style=\"\">-1.30<\/td>\n                            <td style=\"\">2.20<\/td>\n                            <td style=\"\">0.10<\/td>\n                            <td style=\"\">0.70<\/td>\n                            <td style=\"\">-0.90<\/td>\n                            <td style=\"\">0.30<\/td>\n                            <td style=\"\">-3.40<\/td>\n                            <td style=\"\">-1.10<\/td>\n                    <\/tr>\n            <\/tbody>        <!-- \/Table body -->\n\n        <!-- Table footer -->\n        \n        <!-- \/Table footer -->\n    <\/table>\n\n<\/div><style>\n<\/style>\n<style>\n                    \n                                                                                        \/* table font color *\/\n    .wpdt-c.wpDataTablesWrapper table.wpdtSimpleTable,\n    .wpdt-c .wpDataTablesWrapper table.wpDataTable {\n        font-family: Lucida Sans Unicode, Lucida Grande, sans-serif !important;\n    }\n\n            \/* table font size *\/\n    .wpdt-c.wpDataTablesWrapper table.wpdtSimpleTable,\n    .wpdt-c .wpDataTablesWrapper table.wpDataTable {\n        font-size: 20px !important;\n    }\n\n            \n                <\/style>\n<style>\n<\/style>\n<style>\n                            \n                                \/* table font color *\/\n    .wpdt-c.wpDataTablesWrapper table#wpdtSimpleTable-36,\n    .wpdt-c .wpDataTablesWrapper table.wpDataTable.wpDataTableID-36 {\n        font-family: Lucida Sans Unicode, Lucida Grande, sans-serif !important;\n    }\n\n                \n                <\/style>\n\n\n\n\n<p>That&#8217;s &#8220;wide&#8221; format data and the repeated occasions are indicated by the &#8220;_1&#8221; or &#8220;_2&#8221; in the variable names (columns).  However, you could also arrange &#8220;longer&#8221;  by putting the data like this.<\/p>\n\n\n\n<div class=\"wpdt-c wdt-skin-light\">\n    \n    <input type=\"hidden\" id=\"wdtNonceFrontendServerSide_38\" name=\"wdtNonceFrontendServerSide_38\" value=\"2bedc17dd8\" \/><input type=\"hidden\" name=\"_wp_http_referer\" value=\"\/psyctc\/wp-json\/wp\/v2\/docs\/4915\" \/>    <input type=\"hidden\" id=\"table_2_desc\"\n           value='{\"tableId\":\"table_2\",\"tableType\":\"manual\",\"selector\":\"#table_2\",\"responsive\":false,\"responsiveAction\":\"icon\",\"editable\":false,\"inlineEditing\":false,\"infoBlock\":false,\"pagination_top\":0,\"pagination\":0,\"paginationAlign\":\"right\",\"paginationLayout\":\"full_numbers\",\"paginationLayoutMobile\":\"simple\",\"file_location\":\"\",\"tableSkin\":\"light\",\"table_wcag\":0,\"simple_template_id\":0,\"scrollable\":false,\"fixedLayout\":false,\"globalSearch\":false,\"showRowsPerPage\":false,\"popoverTools\":false,\"loader\":1,\"showCartInformation\":0,\"hideBeforeLoad\":false,\"number_format\":2,\"decimalPlaces\":2,\"spinnerSrc\":\"https:\\\/\\\/www.psyctc.org\\\/psyctc\\\/wp-content\\\/plugins\\\/wpdatatables\\\/assets\\\/\\\/img\\\/spinner.gif\",\"groupingEnabled\":false,\"tableWpId\":38,\"dataTableParams\":{\"sDom\":\"BT\\u003C\\u0027clear\\u0027\\u003Et\",\"bSortCellsTop\":false,\"bFilter\":true,\"aLengthMenu\":[[1,5,10,25,50,100,-1],[1,5,10,25,50,100,\"All\"]],\"iDisplayLength\":10,\"columnDefs\":[{\"sType\":\"formatted-num\",\"wdtType\":\"int\",\"bVisible\":false,\"orderable\":true,\"searchable\":true,\"InputType\":\"none\",\"name\":\"wdt_ID\",\"origHeader\":\"wdt_ID\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\"numdata integer  column-wdt_id\",\"aTargets\":[0]},{\"sType\":\"string\",\"wdtType\":\"string\",\"bVisible\":false,\"orderable\":true,\"searchable\":true,\"InputType\":\"none\",\"name\":\"wdt_created_by\",\"origHeader\":\"wdt_created_by\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\" column-wdt_created_by\",\"aTargets\":[1]},{\"sType\":\"date-custom\",\"wdtType\":\"datetime\",\"bVisible\":false,\"orderable\":true,\"searchable\":true,\"InputType\":\"datetime\",\"name\":\"wdt_created_at\",\"origHeader\":\"wdt_created_at\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\" column-wdt_created_at\",\"aTargets\":[2]},{\"sType\":\"string\",\"wdtType\":\"string\",\"bVisible\":false,\"orderable\":true,\"searchable\":true,\"InputType\":\"none\",\"name\":\"wdt_last_edited_by\",\"origHeader\":\"wdt_last_edited_by\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\" column-wdt_last_edited_by\",\"aTargets\":[3]},{\"sType\":\"date-custom\",\"wdtType\":\"datetime\",\"bVisible\":false,\"orderable\":true,\"searchable\":true,\"InputType\":\"datetime\",\"name\":\"wdt_last_edited_at\",\"origHeader\":\"wdt_last_edited_at\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\" column-wdt_last_edited_at\",\"aTargets\":[4]},{\"sType\":\"formatted-num\",\"wdtType\":\"int\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"id\",\"origHeader\":\"id\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\"numdata integer  column-id\",\"aTargets\":[5]},{\"sType\":\"formatted-num\",\"wdtType\":\"int\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"occasion\",\"origHeader\":\"occasion\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\"numdata integer  column-occasion\",\"aTargets\":[6]},{\"sType\":\"formatted-num\",\"wdtType\":\"float\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"item01\",\"origHeader\":\"item01\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\"numdata float  column-item01\",\"aTargets\":[7]},{\"sType\":\"formatted-num\",\"wdtType\":\"float\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"item02\",\"origHeader\":\"item02\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\"numdata float  column-item02\",\"aTargets\":[8]},{\"sType\":\"formatted-num\",\"wdtType\":\"float\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"item03\",\"origHeader\":\"item03\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\"numdata float  column-item03\",\"aTargets\":[9]},{\"sType\":\"formatted-num\",\"wdtType\":\"float\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"item04\",\"origHeader\":\"item04\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\"numdata float  column-item04\",\"aTargets\":[10]},{\"sType\":\"formatted-num\",\"wdtType\":\"float\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"item05\",\"origHeader\":\"item05\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\"numdata float  column-item05\",\"aTargets\":[11]}],\"bAutoWidth\":false,\"order\":[[0,\"asc\"]],\"ordering\":false,\"fixedHeader\":{\"header\":false,\"headerOffset\":0},\"fixedColumns\":false,\"oLanguage\":{\"sSearchPlaceholder\":\"\"},\"buttons\":[],\"bProcessing\":false,\"serverSide\":true,\"ajax\":{\"url\":\"https:\\\/\\\/www.psyctc.org\\\/psyctc\\\/wp-admin\\\/admin-ajax.php?action=get_wdtable&table_id=38\",\"type\":\"POST\"},\"oSearch\":{\"bSmart\":false,\"bRegex\":false,\"sSearch\":\"\"}},\"customRowDisplay\":\"\",\"tabletWidth\":\"1024\",\"mobileWidth\":\"480\",\"renderFilter\":\"footer\",\"advancedFilterEnabled\":false,\"serverSide\":true,\"autoRefreshInterval\":0,\"processing\":true,\"fnServerData\":true,\"columnsFixed\":0,\"sumFunctionsLabel\":\"\",\"avgFunctionsLabel\":\"\",\"minFunctionsLabel\":\"\",\"maxFunctionsLabel\":\"\",\"columnsDecimalPlaces\":{\"wdt_ID\":-1,\"wdt_created_by\":-1,\"wdt_created_at\":-1,\"wdt_last_edited_by\":-1,\"wdt_last_edited_at\":-1,\"id\":-1,\"occasion\":-1,\"item01\":-1,\"item02\":-1,\"item03\":-1,\"item04\":-1,\"item05\":-1},\"columnsThousandsSeparator\":{\"wdt_ID\":0,\"id\":1,\"occasion\":1},\"sumColumns\":[],\"avgColumns\":[],\"sumAvgColumns\":[],\"timeFormat\":\"h:i A\",\"datepickFormat\":\"dd\\\/mm\\\/yy\"}'\/>\n\n    <table id=\"table_2\"\n           class=\"   display nowrap wdt-no-display data-t data-t wpDataTable wpDataTableID-38 \"\n           style=\"\"\n           data-described-by='table_2_desc'\n           data-wpdatatable_id=\"38\">\n        \n        <!-- Table header -->\n        \n<thead>\n<tr>\n                    <th\n                        class=\" wdtheader sort numdata integer \"\n        style=\"\">        wdt_ID<\/th>        <th\n                        class=\" wdtheader sort \"\n        style=\"\">        wdt_created_by<\/th>        <th\n                        class=\" wdtheader sort \"\n        style=\"\">        wdt_created_at<\/th>        <th\n                        class=\" wdtheader sort \"\n        style=\"\">        wdt_last_edited_by<\/th>        <th\n                        class=\" wdtheader sort \"\n        style=\"\">        wdt_last_edited_at<\/th>        <th\n        data-class=\"expand\"                class=\" wdtheader sort numdata integer \"\n        style=\"\">        ID<\/th>        <th\n                        class=\" wdtheader sort numdata integer \"\n        style=\"\">        occasion<\/th>        <th\n                        class=\" wdtheader sort numdata float \"\n        style=\"\">        Item01<\/th>        <th\n                        class=\" wdtheader sort numdata float \"\n        style=\"\">        Item02<\/th>        <th\n                        class=\" wdtheader sort numdata float \"\n        style=\"\">        Item03<\/th>        <th\n                        class=\" wdtheader sort numdata float \"\n        style=\"\">        Item04<\/th>        <th\n                        class=\" wdtheader sort numdata float \"\n        style=\"\">        Item05<\/th>    <\/tr>\n<\/thead>\n        <!-- \/Table header -->\n\n        <!-- Table body -->\n        \n<tbody>\n<!-- Table body -->\n<div data-id=\"38\"\n     class=\"wdt-timeline-item wdt-timeline-table_2\"\n     style=\"\">\n    <div class=\"wdt-table-loader\">\n        <div class=\"wdt-table-loader-row wdt-table-loader-header\">\n            <div class=\"wdt-table-loader-header-cell wdt-animated-background\"><\/div>\n            <div class=\"wdt-table-loader-header-cell wdt-animated-background\"><\/div>\n            <div class=\"wdt-table-loader-header-cell wdt-animated-background\"><\/div>\n        <\/div>\n                    <div class=\"wdt-table-loader-row\">\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n            <\/div>\n                    <div class=\"wdt-table-loader-row\">\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n            <\/div>\n                    <div class=\"wdt-table-loader-row\">\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n            <\/div>\n            <\/div>\n<\/div><!-- \/Table body -->\n                    <tr id=\"table_38_row_0\"\n            data-row-index=\"0\">\n                            <td style=\"\">1<\/td>\n                            <td style=\"\">chris<\/td>\n                            <td style=\"\">22\/05\/2025 08:54 AM<\/td>\n                            <td style=\"\">chris<\/td>\n                            <td style=\"\">22\/05\/2025 08:54 AM<\/td>\n                            <td style=\"\">1<\/td>\n                            <td style=\"\">1<\/td>\n                            <td style=\"\">0.60<\/td>\n                            <td style=\"\">-1.70<\/td>\n                            <td style=\"\">-1.30<\/td>\n                            <td style=\"\">2.20<\/td>\n                            <td style=\"\">0.10<\/td>\n                    <\/tr>\n                            <tr id=\"table_38_row_1\"\n            data-row-index=\"1\">\n                            <td style=\"\">2<\/td>\n                            <td style=\"\">chris<\/td>\n                            <td style=\"\">22\/05\/2025 08:54 AM<\/td>\n                            <td style=\"\">chris<\/td>\n                            <td style=\"\">22\/05\/2025 08:54 AM<\/td>\n                            <td style=\"\">1<\/td>\n                            <td style=\"\">2<\/td>\n                            <td style=\"\">0.70<\/td>\n                            <td style=\"\">-0.90<\/td>\n                            <td style=\"\">0.30<\/td>\n                            <td style=\"\">-3.40<\/td>\n                            <td style=\"\">-1.10<\/td>\n                    <\/tr>\n            <\/tbody>        <!-- \/Table body -->\n\n        <!-- Table footer -->\n        \n        <!-- \/Table footer -->\n    <\/table>\n\n<\/div><style>\n<\/style>\n<style>\n                    \n                                                                                        \/* table font color *\/\n    .wpdt-c.wpDataTablesWrapper table.wpdtSimpleTable,\n    .wpdt-c .wpDataTablesWrapper table.wpDataTable {\n        font-family: Lucida Sans Unicode, Lucida Grande, sans-serif !important;\n    }\n\n            \/* table font size *\/\n    .wpdt-c.wpDataTablesWrapper table.wpdtSimpleTable,\n    .wpdt-c .wpDataTablesWrapper table.wpDataTable {\n        font-size: 20px !important;\n    }\n\n            \n                <\/style>\n<style>\n<\/style>\n<style>\n                            \n                                \/* table font color *\/\n    .wpdt-c.wpDataTablesWrapper table#wpdtSimpleTable-38,\n    .wpdt-c .wpDataTablesWrapper table.wpDataTable.wpDataTableID-38 {\n        font-family: Lucida Sans Unicode, Lucida Grande, sans-serif !important;\n    }\n\n                \n                <\/style>\n\n\n\n\n<p>This is how I generally handle questionnaire data: the occasion has its own variable but each of the items has its own variable giving a mix of long and wide.  You could also format it as truly long, what I think of as &#8220;ultra long&#8221;, like this.<\/p>\n\n\n\n<div class=\"wpdt-c wdt-skin-light\">\n    \n    <input type=\"hidden\" id=\"wdtNonceFrontendServerSide_37\" name=\"wdtNonceFrontendServerSide_37\" value=\"d8bbc836a7\" \/><input type=\"hidden\" name=\"_wp_http_referer\" value=\"\/psyctc\/wp-json\/wp\/v2\/docs\/4915\" \/>    <input type=\"hidden\" id=\"table_3_desc\"\n           value='{\"tableId\":\"table_3\",\"tableType\":\"manual\",\"selector\":\"#table_3\",\"responsive\":false,\"responsiveAction\":\"icon\",\"editable\":false,\"inlineEditing\":false,\"infoBlock\":false,\"pagination_top\":0,\"pagination\":1,\"paginationAlign\":\"right\",\"paginationLayout\":\"full_numbers\",\"paginationLayoutMobile\":\"simple\",\"file_location\":\"\",\"tableSkin\":\"light\",\"table_wcag\":0,\"simple_template_id\":0,\"scrollable\":false,\"fixedLayout\":false,\"globalSearch\":false,\"showRowsPerPage\":false,\"popoverTools\":false,\"loader\":1,\"showCartInformation\":0,\"hideBeforeLoad\":false,\"number_format\":2,\"decimalPlaces\":2,\"spinnerSrc\":\"https:\\\/\\\/www.psyctc.org\\\/psyctc\\\/wp-content\\\/plugins\\\/wpdatatables\\\/assets\\\/\\\/img\\\/spinner.gif\",\"groupingEnabled\":false,\"tableWpId\":37,\"dataTableParams\":{\"sDom\":\"BT\\u003C\\u0027clear\\u0027\\u003Etp\",\"bSortCellsTop\":false,\"bFilter\":true,\"bPaginate\":true,\"sPaginationType\":\"full_numbers\",\"aLengthMenu\":[[1,5,10,25,50,100,-1],[1,5,10,25,50,100,\"All\"]],\"iDisplayLength\":25,\"columnDefs\":[{\"sType\":\"formatted-num\",\"wdtType\":\"int\",\"bVisible\":false,\"orderable\":true,\"searchable\":true,\"InputType\":\"none\",\"name\":\"wdt_ID\",\"origHeader\":\"wdt_ID\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\"numdata integer  column-wdt_id\",\"aTargets\":[0]},{\"sType\":\"string\",\"wdtType\":\"string\",\"bVisible\":false,\"orderable\":true,\"searchable\":true,\"InputType\":\"none\",\"name\":\"wdt_created_by\",\"origHeader\":\"wdt_created_by\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\" column-wdt_created_by\",\"aTargets\":[1]},{\"sType\":\"date-custom\",\"wdtType\":\"datetime\",\"bVisible\":false,\"orderable\":true,\"searchable\":true,\"InputType\":\"datetime\",\"name\":\"wdt_created_at\",\"origHeader\":\"wdt_created_at\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\" column-wdt_created_at\",\"aTargets\":[2]},{\"sType\":\"string\",\"wdtType\":\"string\",\"bVisible\":false,\"orderable\":true,\"searchable\":true,\"InputType\":\"none\",\"name\":\"wdt_last_edited_by\",\"origHeader\":\"wdt_last_edited_by\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\" column-wdt_last_edited_by\",\"aTargets\":[3]},{\"sType\":\"date-custom\",\"wdtType\":\"datetime\",\"bVisible\":false,\"orderable\":true,\"searchable\":true,\"InputType\":\"datetime\",\"name\":\"wdt_last_edited_at\",\"origHeader\":\"wdt_last_edited_at\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\" column-wdt_last_edited_at\",\"aTargets\":[4]},{\"sType\":\"formatted-num\",\"wdtType\":\"int\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"id\",\"origHeader\":\"id\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\"numdata integer  column-id\",\"aTargets\":[5]},{\"sType\":\"formatted-num\",\"wdtType\":\"int\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"occasion\",\"origHeader\":\"occasion\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\"numdata integer  column-occasion\",\"aTargets\":[6]},{\"sType\":\"string\",\"wdtType\":\"string\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"item\",\"origHeader\":\"item\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\" column-item\",\"aTargets\":[7]},{\"sType\":\"formatted-num\",\"wdtType\":\"float\",\"bVisible\":true,\"orderable\":true,\"searchable\":true,\"InputType\":\"text\",\"name\":\"score\",\"origHeader\":\"score\",\"notNull\":false,\"conditionalFormattingRules\":[],\"transformValueRules\":\"\",\"className\":\"numdata float  column-score\",\"aTargets\":[8]}],\"bAutoWidth\":false,\"order\":[[0,\"asc\"]],\"ordering\":false,\"fixedHeader\":{\"header\":false,\"headerOffset\":0},\"fixedColumns\":false,\"oLanguage\":{\"sSearchPlaceholder\":\"\"},\"buttons\":[],\"bProcessing\":false,\"serverSide\":true,\"ajax\":{\"url\":\"https:\\\/\\\/www.psyctc.org\\\/psyctc\\\/wp-admin\\\/admin-ajax.php?action=get_wdtable&table_id=37\",\"type\":\"POST\"},\"oSearch\":{\"bSmart\":false,\"bRegex\":false,\"sSearch\":\"\"}},\"customRowDisplay\":\"\",\"tabletWidth\":\"1024\",\"mobileWidth\":\"480\",\"renderFilter\":\"footer\",\"advancedFilterEnabled\":false,\"serverSide\":true,\"autoRefreshInterval\":0,\"processing\":true,\"fnServerData\":true,\"columnsFixed\":0,\"sumFunctionsLabel\":\"\",\"avgFunctionsLabel\":\"\",\"minFunctionsLabel\":\"\",\"maxFunctionsLabel\":\"\",\"columnsDecimalPlaces\":{\"wdt_ID\":-1,\"wdt_created_by\":-1,\"wdt_created_at\":-1,\"wdt_last_edited_by\":-1,\"wdt_last_edited_at\":-1,\"id\":-1,\"occasion\":-1,\"item\":-1,\"score\":-1},\"columnsThousandsSeparator\":{\"wdt_ID\":0,\"id\":1,\"occasion\":1},\"sumColumns\":[],\"avgColumns\":[],\"sumAvgColumns\":[],\"timeFormat\":\"h:i A\",\"datepickFormat\":\"dd\\\/mm\\\/yy\"}'\/>\n\n    <table id=\"table_3\"\n           class=\"   display nowrap wdt-no-display data-t data-t wpDataTable wpDataTableID-37 \"\n           style=\"\"\n           data-described-by='table_3_desc'\n           data-wpdatatable_id=\"37\">\n        \n        <!-- Table header -->\n        \n<thead>\n<tr>\n                    <th\n                        class=\" wdtheader sort numdata integer \"\n        style=\"\">        wdt_ID<\/th>        <th\n                        class=\" wdtheader sort \"\n        style=\"\">        wdt_created_by<\/th>        <th\n                        class=\" wdtheader sort \"\n        style=\"\">        wdt_created_at<\/th>        <th\n                        class=\" wdtheader sort \"\n        style=\"\">        wdt_last_edited_by<\/th>        <th\n                        class=\" wdtheader sort \"\n        style=\"\">        wdt_last_edited_at<\/th>        <th\n        data-class=\"expand\"                class=\" wdtheader sort numdata integer \"\n        style=\"\">        ID<\/th>        <th\n                        class=\" wdtheader sort numdata integer \"\n        style=\"\">        occasion<\/th>        <th\n                        class=\" wdtheader sort \"\n        style=\"\">        item<\/th>        <th\n                        class=\" wdtheader sort numdata float \"\n        style=\"\">        score<\/th>    <\/tr>\n<\/thead>\n        <!-- \/Table header -->\n\n        <!-- Table body -->\n        \n<tbody>\n<!-- Table body -->\n<div data-id=\"37\"\n     class=\"wdt-timeline-item wdt-timeline-table_3\"\n     style=\"\">\n    <div class=\"wdt-table-loader\">\n        <div class=\"wdt-table-loader-row wdt-table-loader-header\">\n            <div class=\"wdt-table-loader-header-cell wdt-animated-background\"><\/div>\n            <div class=\"wdt-table-loader-header-cell wdt-animated-background\"><\/div>\n            <div class=\"wdt-table-loader-header-cell wdt-animated-background\"><\/div>\n        <\/div>\n                    <div class=\"wdt-table-loader-row\">\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n            <\/div>\n                    <div class=\"wdt-table-loader-row\">\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n            <\/div>\n                    <div class=\"wdt-table-loader-row\">\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n            <\/div>\n                    <div class=\"wdt-table-loader-row\">\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n            <\/div>\n                    <div class=\"wdt-table-loader-row\">\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n            <\/div>\n                    <div class=\"wdt-table-loader-row\">\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n            <\/div>\n                    <div class=\"wdt-table-loader-row\">\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n            <\/div>\n                    <div class=\"wdt-table-loader-row\">\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n            <\/div>\n                    <div class=\"wdt-table-loader-row\">\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n            <\/div>\n                    <div class=\"wdt-table-loader-row\">\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n            <\/div>\n                    <div class=\"wdt-table-loader-row\">\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n                <div class=\"wdt-table-loader-cell wdt-animated-background\"><\/div>\n            <\/div>\n            <\/div>\n<\/div><!-- \/Table body -->\n                    <tr id=\"table_37_row_0\"\n            data-row-index=\"0\">\n                            <td style=\"\">1<\/td>\n                            <td style=\"\">chris<\/td>\n                            <td style=\"\">22\/05\/2025 08:44 AM<\/td>\n                            <td style=\"\">chris<\/td>\n                            <td style=\"\">22\/05\/2025 08:44 AM<\/td>\n                            <td style=\"\">1<\/td>\n                            <td style=\"\">1<\/td>\n                            <td style=\"\">Item01<\/td>\n                            <td style=\"\">0.60<\/td>\n                    <\/tr>\n                            <tr id=\"table_37_row_1\"\n            data-row-index=\"1\">\n                            <td style=\"\">2<\/td>\n                            <td style=\"\">chris<\/td>\n                            <td style=\"\">22\/05\/2025 08:44 AM<\/td>\n                            <td style=\"\">chris<\/td>\n                            <td style=\"\">22\/05\/2025 08:44 AM<\/td>\n                            <td style=\"\">1<\/td>\n                            <td style=\"\">1<\/td>\n                            <td style=\"\">Item02<\/td>\n                            <td style=\"\">-1.70<\/td>\n                    <\/tr>\n                            <tr id=\"table_37_row_2\"\n            data-row-index=\"2\">\n                            <td style=\"\">3<\/td>\n                            <td style=\"\">chris<\/td>\n                            <td style=\"\">22\/05\/2025 08:44 AM<\/td>\n                            <td style=\"\">chris<\/td>\n                            <td style=\"\">22\/05\/2025 08:44 AM<\/td>\n                            <td style=\"\">1<\/td>\n                            <td style=\"\">1<\/td>\n                            <td style=\"\">Item03<\/td>\n                            <td style=\"\">-1.30<\/td>\n                    <\/tr>\n                            <tr id=\"table_37_row_3\"\n            data-row-index=\"3\">\n                            <td style=\"\">4<\/td>\n                            <td style=\"\">chris<\/td>\n                            <td style=\"\">22\/05\/2025 08:44 AM<\/td>\n                            <td style=\"\">chris<\/td>\n                            <td style=\"\">22\/05\/2025 08:44 AM<\/td>\n                            <td style=\"\">1<\/td>\n                            <td style=\"\">1<\/td>\n                            <td style=\"\">Item04<\/td>\n                            <td style=\"\">2.20<\/td>\n                    <\/tr>\n                            <tr id=\"table_37_row_4\"\n            data-row-index=\"4\">\n                            <td style=\"\">5<\/td>\n                            <td style=\"\">chris<\/td>\n                            <td style=\"\">22\/05\/2025 08:44 AM<\/td>\n                            <td style=\"\">chris<\/td>\n                            <td style=\"\">22\/05\/2025 08:44 AM<\/td>\n                            <td style=\"\">1<\/td>\n                            <td style=\"\">1<\/td>\n                            <td style=\"\">Item05<\/td>\n                            <td style=\"\">0.10<\/td>\n                    <\/tr>\n                            <tr id=\"table_37_row_5\"\n            data-row-index=\"5\">\n                            <td style=\"\">6<\/td>\n                            <td style=\"\">chris<\/td>\n                            <td style=\"\">22\/05\/2025 08:44 AM<\/td>\n                            <td style=\"\">chris<\/td>\n                            <td style=\"\">22\/05\/2025 08:44 AM<\/td>\n                            <td style=\"\">1<\/td>\n                            <td style=\"\">2<\/td>\n                            <td style=\"\">Item01<\/td>\n                            <td style=\"\">0.70<\/td>\n                    <\/tr>\n                            <tr id=\"table_37_row_6\"\n            data-row-index=\"6\">\n                            <td style=\"\">7<\/td>\n                            <td style=\"\">chris<\/td>\n                            <td style=\"\">22\/05\/2025 08:44 AM<\/td>\n                            <td style=\"\">chris<\/td>\n                            <td style=\"\">22\/05\/2025 08:44 AM<\/td>\n                            <td style=\"\">1<\/td>\n                            <td style=\"\">2<\/td>\n                            <td style=\"\">Item02<\/td>\n                            <td style=\"\">-0.90<\/td>\n                    <\/tr>\n                            <tr id=\"table_37_row_7\"\n            data-row-index=\"7\">\n                            <td style=\"\">8<\/td>\n                            <td style=\"\">chris<\/td>\n                            <td style=\"\">22\/05\/2025 08:44 AM<\/td>\n                            <td style=\"\">chris<\/td>\n                            <td style=\"\">22\/05\/2025 08:44 AM<\/td>\n                            <td style=\"\">1<\/td>\n                            <td style=\"\">2<\/td>\n                            <td style=\"\">Item03<\/td>\n                            <td style=\"\">0.30<\/td>\n                    <\/tr>\n                            <tr id=\"table_37_row_8\"\n            data-row-index=\"8\">\n                            <td style=\"\">9<\/td>\n                            <td style=\"\">chris<\/td>\n                            <td style=\"\">22\/05\/2025 08:44 AM<\/td>\n                            <td style=\"\">chris<\/td>\n                            <td style=\"\">22\/05\/2025 08:44 AM<\/td>\n                            <td style=\"\">1<\/td>\n                            <td style=\"\">2<\/td>\n                            <td style=\"\">Item04<\/td>\n                            <td style=\"\">-3.40<\/td>\n                    <\/tr>\n                            <tr id=\"table_37_row_9\"\n            data-row-index=\"9\">\n                            <td style=\"\">10<\/td>\n                            <td style=\"\">chris<\/td>\n                            <td style=\"\">22\/05\/2025 08:44 AM<\/td>\n                            <td style=\"\">chris<\/td>\n                            <td style=\"\">22\/05\/2025 08:44 AM<\/td>\n                            <td style=\"\">1<\/td>\n                            <td style=\"\">2<\/td>\n                            <td style=\"\">Item05<\/td>\n                            <td style=\"\">-1.10<\/td>\n                    <\/tr>\n            <\/tbody>        <!-- \/Table body -->\n\n        <!-- Table footer -->\n        \n        <!-- \/Table footer -->\n    <\/table>\n\n<\/div><style>\n<\/style>\n<style>\n                    \n                                                                                        \/* table font color *\/\n    .wpdt-c.wpDataTablesWrapper table.wpdtSimpleTable,\n    .wpdt-c .wpDataTablesWrapper table.wpDataTable {\n        font-family: Lucida Sans Unicode, Lucida Grande, sans-serif !important;\n    }\n\n            \/* table font size *\/\n    .wpdt-c.wpDataTablesWrapper table.wpdtSimpleTable,\n    .wpdt-c .wpDataTablesWrapper table.wpDataTable {\n        font-size: 20px !important;\n    }\n\n            \n                <\/style>\n<style>\n<\/style>\n<style>\n                            \n                                \/* table font color *\/\n    .wpdt-c.wpDataTablesWrapper table#wpdtSimpleTable-37,\n    .wpdt-c .wpDataTablesWrapper table.wpDataTable.wpDataTableID-37 {\n        font-family: Lucida Sans Unicode, Lucida Grande, sans-serif !important;\n    }\n\n                \n                <\/style>\n\n\n\n\n<p>They all have exactly the same data but generally the wide format (&#8220;fat&#8221;) is a bad way to handle things, it either fixes the maximum number of occasions, in this little example it cannot be more than two, or else you often have a very wide layout with lots of empty cells to the right.<\/p>\n\n\n\n<p>The mixed format is good where you might be doing a lot of analyses, say internal reliability or other psychometric work across the items.  However, the truly long format is generally how database programmers will format things as it makes it possible to any analyses you want (and they, and increasingly myself too!) are very comfortable swinging data around from one format to another.  Some database software will organise things in that truly long format internally even if they don&#8217;t show it that way.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Try also<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.psyctc.org\/psyctc\/glossary2\/dataset-and-database\/\" title=\"\">Dataset and database<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.psyctc.org\/psyctc\/glossary2\/rdbms-relational-database-management-system\/\">RDBMS: Relational Database Management System<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.psyctc.org\/psyctc\/glossary2\/statistical-software\/\" title=\"\">Statistical software<\/a><\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Chapters<\/h4>\n\n\n\n<p>Not covered in the OMbook.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Online resources<\/h4>\n\n\n\n<p>None specifically though pretty much all <a href=\"https:\/\/shiny.psyctc.org\/index.html\" target=\"_blank\" rel=\"noopener\" title=\"\">my shiny apps<\/a> that handle data will use mixed or truly long format data.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Dates<\/h4>\n\n\n\n<p>First created 22.v.25.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Is what it says! A dataset that is long and thin! Details So what? Well, often in our fields we have repeated, nested data, e.g. multiple completions of measures by the same person over time. You can arrange this in some database or statistical computer package like this: That&#8217;s &#8220;wide&#8221; format data and the repeated &hellip; <a href=\"https:\/\/www.psyctc.org\/psyctc\/glossary2\/long-thin-format-data\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Long (&#8220;thin&#8221;) format data<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_category":[],"glossaries":[],"doc_tag":[],"knowledge_base":[],"class_list":["post-4915","docs","type-docs","status-publish","hentry"],"year_month":"2026-04","word_count":315,"total_views":"296","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"chris","author_nicename":"chris","author_url":"https:\/\/www.psyctc.org\/psyctc\/author\/chris\/"},"doc_category_info":[],"doc_tag_info":[],"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/www.psyctc.org\/psyctc\/wp-json\/wp\/v2\/docs\/4915","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.psyctc.org\/psyctc\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.psyctc.org\/psyctc\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.psyctc.org\/psyctc\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.psyctc.org\/psyctc\/wp-json\/wp\/v2\/comments?post=4915"}],"version-history":[{"count":5,"href":"https:\/\/www.psyctc.org\/psyctc\/wp-json\/wp\/v2\/docs\/4915\/revisions"}],"predecessor-version":[{"id":4923,"href":"https:\/\/www.psyctc.org\/psyctc\/wp-json\/wp\/v2\/docs\/4915\/revisions\/4923"}],"wp:attachment":[{"href":"https:\/\/www.psyctc.org\/psyctc\/wp-json\/wp\/v2\/media?parent=4915"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/www.psyctc.org\/psyctc\/wp-json\/wp\/v2\/doc_category?post=4915"},{"taxonomy":"glossaries","embeddable":true,"href":"https:\/\/www.psyctc.org\/psyctc\/wp-json\/wp\/v2\/glossaries?post=4915"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.psyctc.org\/psyctc\/wp-json\/wp\/v2\/doc_tag?post=4915"},{"taxonomy":"knowledge_base","embeddable":true,"href":"https:\/\/www.psyctc.org\/psyctc\/wp-json\/wp\/v2\/knowledge_base?post=4915"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}