{"id":841,"date":"2026-03-18T07:24:41","date_gmt":"2026-03-18T07:24:41","guid":{"rendered":"https:\/\/datadandies.nl\/?p=841"},"modified":"2026-03-18T07:24:41","modified_gmt":"2026-03-18T07:24:41","slug":"months-in-your-column-headers-put-the-months-into-one-column-using-unpivot-in-snowflake-sql","status":"publish","type":"post","link":"https:\/\/datadandies.nl\/index.php\/2026\/03\/18\/months-in-your-column-headers-put-the-months-into-one-column-using-unpivot-in-snowflake-sql\/","title":{"rendered":"Months in your column headers? Put the months into one column using UNPIVOT in Snowflake SQL"},"content":{"rendered":"\n<p>Ever received data where the months were column headers, like below?<\/p>\n\n\n\n<p>Ever felt the need to do something unspeakable to your keyboard, right after?<\/p>\n\n\n\n<p>You are not alone.<\/p>\n\n\n\n<p>However! Fear not, because there is salvation. Thou needst only use the UNPIVOT function in Snowflake, and rest, peace and Eden will return to your data landscape.<\/p>\n\n\n\n<p>Behold, the cure:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro padding-bottom-disabled cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1.3rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#D4D4D4;--cbp-line-number-width:calc(2 * 0.6 * 1.3rem);line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:16px 0 0 16px;width:100%;text-align:left;background-color:#1e1e1e\"><span style=\"background:#c7c7c7;padding:0.3rem 0.5rem 0.2rem;border-radius:1rem;font-size:0.8em;line-height:1;height:1.25rem;text-align:center;display:inline-flex;align-items:center;justify-content:center;color:#1e1e1e\">SQL<\/span><\/span><span role=\"button\" tabindex=\"0\" data-code=\"WITH MONTHLY_SALES AS (\n\n\u00a0\u00a0\u00a0 SELECT\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 *\n\n\u00a0\u00a0\u00a0 FROM (VALUES\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (1, 'electronics', 100, 200, 300, 100),\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (2, 'clothes', 100, 300, 150, 200),\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (3, 'cars', 200, 400, 100, 50)\n\n\u00a0\u00a0\u00a0 ) as t(EMPID, DEPARTMENT, JAN, FEB, MAR, APR)\n\n)\n\nSELECT\n\n*\n\nFROM MONTHLY_SALES\n\nUNPIVOT(SALES FOR MONTH IN (JAN, FEB, MAR, APR))\n;\" style=\"color:#D4D4D4;display:none\" aria-label=\"Kopieer\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki dark-plus\" style=\"background-color: #1E1E1E\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #569CD6\">WITH<\/span><span style=\"color: #D4D4D4\"> MONTHLY_SALES <\/span><span style=\"color: #569CD6\">AS<\/span><span style=\"color: #D4D4D4\"> (<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D4D4D4\">\u00a0\u00a0\u00a0 <\/span><span style=\"color: #569CD6\">SELECT<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D4D4D4\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 *<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D4D4D4\">\u00a0\u00a0\u00a0 <\/span><span style=\"color: #569CD6\">FROM<\/span><span style=\"color: #D4D4D4\"> (<\/span><span style=\"color: #569CD6\">VALUES<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D4D4D4\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (<\/span><span style=\"color: #B5CEA8\">1<\/span><span style=\"color: #D4D4D4\">, <\/span><span style=\"color: #CE9178\">&#39;electronics&#39;<\/span><span style=\"color: #D4D4D4\">, <\/span><span style=\"color: #B5CEA8\">100<\/span><span style=\"color: #D4D4D4\">, <\/span><span style=\"color: #B5CEA8\">200<\/span><span style=\"color: #D4D4D4\">, <\/span><span style=\"color: #B5CEA8\">300<\/span><span style=\"color: #D4D4D4\">, <\/span><span style=\"color: #B5CEA8\">100<\/span><span style=\"color: #D4D4D4\">),<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D4D4D4\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (<\/span><span style=\"color: #B5CEA8\">2<\/span><span style=\"color: #D4D4D4\">, <\/span><span style=\"color: #CE9178\">&#39;clothes&#39;<\/span><span style=\"color: #D4D4D4\">, <\/span><span style=\"color: #B5CEA8\">100<\/span><span style=\"color: #D4D4D4\">, <\/span><span style=\"color: #B5CEA8\">300<\/span><span style=\"color: #D4D4D4\">, <\/span><span style=\"color: #B5CEA8\">150<\/span><span style=\"color: #D4D4D4\">, <\/span><span style=\"color: #B5CEA8\">200<\/span><span style=\"color: #D4D4D4\">),<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D4D4D4\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (<\/span><span style=\"color: #B5CEA8\">3<\/span><span style=\"color: #D4D4D4\">, <\/span><span style=\"color: #CE9178\">&#39;cars&#39;<\/span><span style=\"color: #D4D4D4\">, <\/span><span style=\"color: #B5CEA8\">200<\/span><span style=\"color: #D4D4D4\">, <\/span><span style=\"color: #B5CEA8\">400<\/span><span style=\"color: #D4D4D4\">, <\/span><span style=\"color: #B5CEA8\">100<\/span><span style=\"color: #D4D4D4\">, <\/span><span style=\"color: #B5CEA8\">50<\/span><span style=\"color: #D4D4D4\">)<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D4D4D4\">\u00a0\u00a0\u00a0 ) <\/span><span style=\"color: #569CD6\">as<\/span><span style=\"color: #D4D4D4\"> t(EMPID, DEPARTMENT, JAN, FEB, MAR, APR)<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D4D4D4\">)<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #569CD6\">SELECT<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D4D4D4\">*<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #569CD6\">FROM<\/span><span style=\"color: #D4D4D4\"> MONTHLY_SALES<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D4D4D4\">UNPIVOT(SALES <\/span><span style=\"color: #569CD6\">FOR<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #569CD6\">MONTH<\/span><span style=\"color: #D4D4D4\"> <\/span><span style=\"color: #569CD6\">IN<\/span><span style=\"color: #D4D4D4\"> (JAN, FEB, MAR, APR))<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D4D4D4\">;<\/span><\/span><\/code><\/pre><span style=\"display:flex;align-items:flex-end;padding:10px;width:100%;justify-content:flex-end;background-color:#1E1E1E;color:#c7c7c7;font-size:12px;line-height:1;position:relative\">SQL<\/span><\/div>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"520\" src=\"https:\/\/datadandies.nl\/wp-content\/uploads\/2026\/03\/20260323-Turning-months-in-column-headers-to-months-in-one-column-using-unpivot-1024x520.png\" alt=\"\" class=\"wp-image-842\" srcset=\"https:\/\/datadandies.nl\/wp-content\/uploads\/2026\/03\/20260323-Turning-months-in-column-headers-to-months-in-one-column-using-unpivot-1024x520.png 1024w, https:\/\/datadandies.nl\/wp-content\/uploads\/2026\/03\/20260323-Turning-months-in-column-headers-to-months-in-one-column-using-unpivot-300x152.png 300w, https:\/\/datadandies.nl\/wp-content\/uploads\/2026\/03\/20260323-Turning-months-in-column-headers-to-months-in-one-column-using-unpivot-768x390.png 768w, https:\/\/datadandies.nl\/wp-content\/uploads\/2026\/03\/20260323-Turning-months-in-column-headers-to-months-in-one-column-using-unpivot-1536x780.png 1536w, https:\/\/datadandies.nl\/wp-content\/uploads\/2026\/03\/20260323-Turning-months-in-column-headers-to-months-in-one-column-using-unpivot-2048x1040.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ever received data where the months were column headers, like below? Ever felt the need to do something unspeakable to your keyboard, right after? You are not alone. However! Fear not, because there is salvation. Thou needst only use the UNPIVOT function in Snowflake, and rest, peace and Eden will return to your data landscape.&hellip;<\/p>\n<p class=\"more-link\"><a href=\"https:\/\/datadandies.nl\/index.php\/2026\/03\/18\/months-in-your-column-headers-put-the-months-into-one-column-using-unpivot-in-snowflake-sql\/\" class=\"themebutton\">Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[40,4],"class_list":["post-841","post","type-post","status-publish","format-standard","hentry","category-blog","tag-snowflake","tag-sql"],"_links":{"self":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts\/841","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/comments?post=841"}],"version-history":[{"count":1,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts\/841\/revisions"}],"predecessor-version":[{"id":843,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/posts\/841\/revisions\/843"}],"wp:attachment":[{"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/media?parent=841"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/categories?post=841"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datadandies.nl\/index.php\/wp-json\/wp\/v2\/tags?post=841"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}