Pivot rows into columns

Reviewed by Johannes Åkesson

Last updated Apr 25, 2024

1 min read

For scenarios like forecasting, SQL Spreads pivots rows from SQL Server into columns in Excel. Changes made to these columns will be saved back as rows in SQL Server.

Try SQL Spreads for free

Try SQL Spreads during 14 days for free. The free trial is the fully
functional, time-limited only product.

Try Excel Add-In for Free

14-days Free Trial. No credit card required.

img:is([sizes=auto i],[sizes^="auto," i]){contain-intrinsic-size:3000px 1500px}img.wp-smiley,img.emoji{display:inline !important;border:none !important;box-shadow:none !important;height:1em !important;width:1em !important;margin:0 .07em !important;vertical-align:-.1em !important;background:none !important;padding:0 !important}:root{--wp-block-synced-color:#7a00df;--wp-block-synced-color--rgb:122,0,223;--wp-bound-block-color:var(--wp-block-synced-color);--wp-editor-canvas-background:#ddd;--wp-admin-theme-color:#007cba;--wp-admin-theme-color--rgb:0,124,186;--wp-admin-theme-color-darker-10:#006ba1;--wp-admin-theme-color-darker-10--rgb:0,107,160.5;--wp-admin-theme-color-darker-20:#005a87;--wp-admin-theme-color-darker-20--rgb:0,90,135;--wp-admin-border-width-focus:2px}@media (min-resolution:192dpi){:root{--wp-admin-border-width-focus:1.5px}}.wp-element-button{cursor:pointer}:root .has-very-light-gray-background-color{background-color:#eee}:root .has-very-dark-gray-background-color{background-color:#313131}:root .has-very-light-gray-color{color:#eee}:root .has-very-dark-gray-color{color:#313131}:root .has-vivid-green-cyan-to-vivid-cyan-blue-gradient-background{background:linear-gradient(135deg,#00d084,#0693e3)}:root .has-purple-crush-gradient-background{background:linear-gradient(135deg,#34e2e4,#4721fb 50%,#ab1dfe)}:root .has-hazy-dawn-gradient-background{background:linear-gradient(135deg,#faaca8,#dad0ec)}:root .has-subdued-olive-gradient-background{background:linear-gradient(135deg,#fafae1,#67a671)}:root .has-atomic-cream-gradient-background{background:linear-gradient(135deg,#fdd79a,#004a59)}:root .has-nightshade-gradient-background{background:linear-gradient(135deg,#330968,#31cdcf)}:root .has-midnight-gradient-background{background:linear-gradient(135deg,#020381,#2874fc)}:root{--wp--preset--font-size--normal:16px;--wp--preset--font-size--huge:42px}.has-regular-font-size{font-size:1em}.has-larger-font-size{font-size:2.625em}.has-normal-font-size{font-size:var(--wp--preset--font-size--normal)}.has-huge-font-size{font-size:var(--wp--preset--font-size--huge)}:root .has-text-align-center{text-align:center}:root .has-text-align-left{text-align:left}:root .has-text-align-right{text-align:right}.has-fit-text{white-space:nowrap !important}#end-resizable-editor-section{display:none}.aligncenter{clear:both}.items-justified-left{justify-content:flex-start}.items-justified-center{justify-content:center}.items-justified-right{justify-content:flex-end}.items-justified-space-between{justify-content:space-between}.screen-reader-text{word-wrap:normal !important;border:0;clip-path:inset(50%);height:1px;margin:-1px;overflow:hidden;padding:0;position:absolute;width:1px}.screen-reader-text:focus{background-color:#ddd;clip-path:none;color:#444;display:block;font-size:1em;height:auto;left:5px;line-height:normal;padding:15px 23px 14px;text-decoration:none;top:5px;width:auto;z-index:100000}html :where(.has-border-color){border-style:solid}html :where([style*=border-color]){border-style:solid}html :where([style*=border-top-color]){border-top-style:solid}html :where([style*=border-right-color]){border-right-style:solid}html :where([style*=border-bottom-color]){border-bottom-style:solid}html :where([style*=border-left-color]){border-left-style:solid}html :where([style*=border-width]){border-style:solid}html :where([style*=border-top-width]){border-top-style:solid}html :where([style*=border-right-width]){border-right-style:solid}html :where([style*=border-bottom-width]){border-bottom-style:solid}html :where([style*=border-left-width]){border-left-style:solid}html :where(img[class*=wp-image-]){height:auto;max-width:100%}:where(figure){margin:0 0 1em}html :where(.is-position-sticky){--wp-admin--admin-bar--position-offset:var(--wp-admin--admin-bar--height,0px)}@media screen and (max-width:600px){html :where(.is-position-sticky){--wp-admin--admin-bar--position-offset:0px}}.wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none}:root{--wp-internal-comment:"Placeholder for wp_hoist_late_printed_styles() to replace with the block styles printed at wp_footer."}:root{--wp-internal-comment:"Placeholder for wp_hoist_late_printed_styles() to replace with the global-styles printed at wp_footer."}@media (min-width: 1025px){body .uag-hide-desktop.uagb-google-map__wrap,body .uag-hide-desktop{display:none !important}}@media (min-width: 768px) and (max-width: 1024px){body .uag-hide-tab.uagb-google-map__wrap,body .uag-hide-tab{display:none !important}}@media (max-width: 767px){body .uag-hide-mob.uagb-google-map__wrap,body .uag-hide-mob{display:none !important}}.align-icons-center{display:flex;justify-content:center;gap:13px}.thankyou-block .wp-block-group__inner-container{display:flex;flex-direction:column;gap:16px;padding:56px 0}.thankyou-block .wp-block-group__inner-container h1{line-height:52px}.link-to-visit a{justify-content:center;display:flex;gap:5px;align-items:center;color:#14944d !important;text-align:center;font-size:18px;font-style:normal;font-weight:700;line-height:30px}.thk-content{max-width:560px;margin:auto}.faq-v2 .hidden{display:none}@media screen and (max-width: 568px){.thankyou-block .wp-block-group__inner-container h1{font-size:30px !important;line-height:35px}}@media screen and (min-width: 782px){.forminator-pagination-start .forminator-row:nth-child(2){margin-bottom:-20px}.forminator-pagination{width:70%;margin:auto;z-index:9999999;position:relative}.forminator-field .first-step .content{margin-top:-80px !important}.forminator-pagination-start .forminator-row:nth-child(2) #email-1{margin-bottom:5px !important}.forminator-pagination-start .forminator-row:nth-child(3){margin-bottom:0px !important}.forminator-pagination-footer{bottom:30px;right:0px;width:100%;position:absolute}.forminator-ui.forminator-custom-form-10151.forminator-design--default .forminator-step-label{top:3px;left:8px}.forminator-ui.forminator-custom-form-10151.forminator-design--default .forminator-button-submit{position:absolute !important;left:280px;z-index:9999999999;font-size:18px !important;min-width:150px !important;display:flex !important;justify-content:center !important;padding:16px 24px !important;border-radius:10px !important;margin-top:-50px !important}.forminator-checkbox-label{font-size:15px}}.forminator-row #checkbox-1{margin-top:-20px !important}.forminator-pagination-footer:has(button.forminator-button-submit) .forminator-button-back,.forminator-ui.forminator-custom-form-10151.forminator-design--default .forminator-step-4{display:none !important}.forminator-pagination .forminator-pagination--content .forminator-row:nth-child(2){margin-bottom:0 !important}@media screen and (max-width: 782px){.forminator-ui.forminator-custom-form-10151.forminator-design--default .forminator-checkbox-label{font-size:12px !important}.forminator-row #checkbox-1{margin-top:8px !important}.forminator-pagination-steps{display:flex !important;align-items:center}.forminator-break{width:100% !important;height:1px !important}.forminator-pagination-footer{position:relative;display:flex !important;justify-content:space-between;align-items:center}.forminator-pagination-footer *{width:40% !important;margin:0}.forminator-pagination-footer .forminator-button-submit{width:100% !important}.forminator-ui.forminator-custom-form-10151.forminator-design--default .forminator-step-label{top:3px !important;left:8px !important}}.forminator-break:first-child,.forminator-break:nth-last-child(1),.forminator-break:nth-child(9),.forminator-step-4,#forminator-module-10151 .forminator-step-4{display:none !important}.forminator-select.forminator-select-dropdown-container--open .forminator-select-dropdown .select2-results .select2-results__options{max-height:420px !important}.select2-results__options li{border-bottom:1px solid #b3bbcd}.lightbox{position:fixed !important;top:0 !important;left:0 !important;bottom:0 !important}.lb-outerContainer{margin-top:2%}.lightboxOverlay{width:100% !important}