{"id":4075,"date":"2023-08-28T20:17:47","date_gmt":"2023-08-28T20:17:47","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/?p=4075"},"modified":"2026-01-15T17:55:24","modified_gmt":"2026-01-15T17:55:24","slug":"a-step-by-step-guide-to-data-pivoting-in-dataworq","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/a-step-by-step-guide-to-data-pivoting-in-dataworq\/","title":{"rendered":"How Do I Pivot (or Unpivot) Data in DataWORQ to Create an Analysis-Ready Dataset?"},"content":{"rendered":"<p><script src=\"https:\/\/fast.wistia.com\/embed\/medias\/mc0nnd3f7p.jsonp\" async><\/script><script src=\"https:\/\/fast.wistia.com\/assets\/external\/E-v1.js\" async><\/script><\/p>\n<div class=\"wistia_responsive_padding\" style=\"padding: 56.25% 0 0 0; position: relative;\">\n<div class=\"wistia_responsive_wrapper\" style=\"height: 100%; left: 0; position: absolute; top: 0; width: 100%;\">\n<div class=\"wistia_embed wistia_async_mc0nnd3f7p seo=true videoFoam=true\" style=\"height: 100%; position: relative; width: 100%;\">\n<div class=\"wistia_swatch\" style=\"height: 100%; left: 0; opacity: 0; overflow: hidden; position: absolute; top: 0; transition: opacity 200ms; width: 100%;\"><img decoding=\"async\" style=\"filter: blur(5px); height: 100%; object-fit: contain; width: 100%;\" src=\"https:\/\/fast.wistia.com\/embed\/medias\/mc0nnd3f7p\/swatch\" alt=\"\" aria-hidden=\"true\" \/><\/div>\n<\/div>\n<\/div>\n<\/div>\n<p>Learn how to master the art of data pivoting in DataWORQ with this step-by-step tutorial. Aimed at business users looking to streamline Extended Planning &amp; Analysis (xP&amp;A), this article guides you from the point of pulling an unpivoted dataset from Excel to transforming it into a neatly pivoted dataset. We explain how to utilize the Pivot node, make the right column selections, and preview your changes before confirming them. Gain valuable insights into making your data more organized and easy to analyze.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Learn how to master the art of data pivoting in DataWORQ with this step-by-step tutorial. Aimed at business users looking to streamline Extended Planning &amp; Analysis (xP&amp;A), this article guides you from the point of pulling an unpivoted dataset from Excel to transforming it into a neatly pivoted dataset. We explain how to utilize the&hellip;<\/p>\n","protected":false},"author":5,"featured_media":4102,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[100,27],"tags":[101,99],"class_list":["post-4075","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dataworq","category-quebit-value","tag-dataworq","tag-quebit-value-dataworq"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How Do I Pivot (or Unpivot) Data in DataWORQ to Create an Analysis-Ready Dataset? - QueBIT<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/quebit.com\/askquebit\/a-step-by-step-guide-to-data-pivoting-in-dataworq\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How Do I Pivot (or Unpivot) Data in DataWORQ to Create an Analysis-Ready Dataset? - QueBIT\" \/>\n<meta property=\"og:description\" content=\"Learn how to master the art of data pivoting in DataWORQ with this step-by-step tutorial. Aimed at business users looking to streamline Extended Planning &amp; Analysis (xP&amp;A), this article guides you from the point of pulling an unpivoted dataset from Excel to transforming it into a neatly pivoted dataset. We explain how to utilize the&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/a-step-by-step-guide-to-data-pivoting-in-dataworq\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-28T20:17:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-15T17:55:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2023\/09\/Pivot-Data.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"525\" \/>\n\t<meta property=\"og:image:height\" content=\"292\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jennifer Field\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jennifer Field\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/a-step-by-step-guide-to-data-pivoting-in-dataworq\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/a-step-by-step-guide-to-data-pivoting-in-dataworq\\\/\"},\"author\":{\"name\":\"Jennifer Field\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/082a9c4156466b9cdad2632e3de62601\"},\"headline\":\"How Do I Pivot (or Unpivot) Data in DataWORQ to Create an Analysis-Ready Dataset?\",\"datePublished\":\"2023-08-28T20:17:47+00:00\",\"dateModified\":\"2026-01-15T17:55:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/a-step-by-step-guide-to-data-pivoting-in-dataworq\\\/\"},\"wordCount\":98,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/a-step-by-step-guide-to-data-pivoting-in-dataworq\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2023\\\/09\\\/Pivot-Data.jpg\",\"keywords\":[\"DataWORQ\",\"QueBIT Value DataWORQ\"],\"articleSection\":[\"DataWORQ\",\"QueBIT Value\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/a-step-by-step-guide-to-data-pivoting-in-dataworq\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/a-step-by-step-guide-to-data-pivoting-in-dataworq\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/a-step-by-step-guide-to-data-pivoting-in-dataworq\\\/\",\"name\":\"How Do I Pivot (or Unpivot) Data in DataWORQ to Create an Analysis-Ready Dataset? - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/a-step-by-step-guide-to-data-pivoting-in-dataworq\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/a-step-by-step-guide-to-data-pivoting-in-dataworq\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2023\\\/09\\\/Pivot-Data.jpg\",\"datePublished\":\"2023-08-28T20:17:47+00:00\",\"dateModified\":\"2026-01-15T17:55:24+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/082a9c4156466b9cdad2632e3de62601\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/a-step-by-step-guide-to-data-pivoting-in-dataworq\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/a-step-by-step-guide-to-data-pivoting-in-dataworq\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/a-step-by-step-guide-to-data-pivoting-in-dataworq\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2023\\\/09\\\/Pivot-Data.jpg\",\"contentUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2023\\\/09\\\/Pivot-Data.jpg\",\"width\":525,\"height\":292},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/a-step-by-step-guide-to-data-pivoting-in-dataworq\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How Do I Pivot (or Unpivot) Data in DataWORQ to Create an Analysis-Ready Dataset?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\",\"name\":\"QueBIT\",\"description\":\"QueBIT\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/082a9c4156466b9cdad2632e3de62601\",\"name\":\"Jennifer Field\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g\",\"caption\":\"Jennifer Field\"},\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/author\\\/quebit\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How Do I Pivot (or Unpivot) Data in DataWORQ to Create an Analysis-Ready Dataset? - QueBIT","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/quebit.com\/askquebit\/a-step-by-step-guide-to-data-pivoting-in-dataworq\/","og_locale":"en_US","og_type":"article","og_title":"How Do I Pivot (or Unpivot) Data in DataWORQ to Create an Analysis-Ready Dataset? - QueBIT","og_description":"Learn how to master the art of data pivoting in DataWORQ with this step-by-step tutorial. Aimed at business users looking to streamline Extended Planning &amp; Analysis (xP&amp;A), this article guides you from the point of pulling an unpivoted dataset from Excel to transforming it into a neatly pivoted dataset. We explain how to utilize the&hellip;","og_url":"https:\/\/quebit.com\/askquebit\/a-step-by-step-guide-to-data-pivoting-in-dataworq\/","og_site_name":"QueBIT","article_published_time":"2023-08-28T20:17:47+00:00","article_modified_time":"2026-01-15T17:55:24+00:00","og_image":[{"width":525,"height":292,"url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2023\/09\/Pivot-Data.jpg","type":"image\/jpeg"}],"author":"Jennifer Field","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jennifer Field","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quebit.com\/askquebit\/a-step-by-step-guide-to-data-pivoting-in-dataworq\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/a-step-by-step-guide-to-data-pivoting-in-dataworq\/"},"author":{"name":"Jennifer Field","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/082a9c4156466b9cdad2632e3de62601"},"headline":"How Do I Pivot (or Unpivot) Data in DataWORQ to Create an Analysis-Ready Dataset?","datePublished":"2023-08-28T20:17:47+00:00","dateModified":"2026-01-15T17:55:24+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/a-step-by-step-guide-to-data-pivoting-in-dataworq\/"},"wordCount":98,"commentCount":0,"image":{"@id":"https:\/\/quebit.com\/askquebit\/a-step-by-step-guide-to-data-pivoting-in-dataworq\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2023\/09\/Pivot-Data.jpg","keywords":["DataWORQ","QueBIT Value DataWORQ"],"articleSection":["DataWORQ","QueBIT Value"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quebit.com\/askquebit\/a-step-by-step-guide-to-data-pivoting-in-dataworq\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/a-step-by-step-guide-to-data-pivoting-in-dataworq\/","url":"https:\/\/quebit.com\/askquebit\/a-step-by-step-guide-to-data-pivoting-in-dataworq\/","name":"How Do I Pivot (or Unpivot) Data in DataWORQ to Create an Analysis-Ready Dataset? - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/a-step-by-step-guide-to-data-pivoting-in-dataworq\/#primaryimage"},"image":{"@id":"https:\/\/quebit.com\/askquebit\/a-step-by-step-guide-to-data-pivoting-in-dataworq\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2023\/09\/Pivot-Data.jpg","datePublished":"2023-08-28T20:17:47+00:00","dateModified":"2026-01-15T17:55:24+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/082a9c4156466b9cdad2632e3de62601"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/a-step-by-step-guide-to-data-pivoting-in-dataworq\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/a-step-by-step-guide-to-data-pivoting-in-dataworq\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quebit.com\/askquebit\/a-step-by-step-guide-to-data-pivoting-in-dataworq\/#primaryimage","url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2023\/09\/Pivot-Data.jpg","contentUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2023\/09\/Pivot-Data.jpg","width":525,"height":292},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/a-step-by-step-guide-to-data-pivoting-in-dataworq\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"How Do I Pivot (or Unpivot) Data in DataWORQ to Create an Analysis-Ready Dataset?"}]},{"@type":"WebSite","@id":"https:\/\/quebit.com\/askquebit\/#website","url":"https:\/\/quebit.com\/askquebit\/","name":"QueBIT","description":"QueBIT","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/quebit.com\/askquebit\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/082a9c4156466b9cdad2632e3de62601","name":"Jennifer Field","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g","caption":"Jennifer Field"},"url":"https:\/\/quebit.com\/askquebit\/author\/quebit\/"}]}},"_links":{"self":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/4075","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/comments?post=4075"}],"version-history":[{"count":3,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/4075\/revisions"}],"predecessor-version":[{"id":4897,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/4075\/revisions\/4897"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media\/4102"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=4075"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=4075"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=4075"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}