--- title: "TRANSPOSE function in Excel: syntax and examples | PracticeExcel" description: "How to use TRANSPOSE in Excel and Google Sheets: turn rows into columns with a formula that stays linked to the source." canonical_url: "https://practiceexcelonline.com/functions/transpose" locale: en meta: "og:description": "How to use TRANSPOSE in Excel and Google Sheets: turn rows into columns with a formula that stays linked to the source." "og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~VFJBTlNQT1NFIGZ1bmN0aW9uIGluIEV4Y2VsOiBzeW50YXggYW5kIGV4YW1wbGVz%2Cdescription_~SG93IHRvIHVzZSBUUkFOU1BPU0UgaW4gRXhjZWwgYW5kIEdvb2dsZSBTaGVldHM6IHR1cm4gcm93cyBpbnRvIGNvbHVtbnMgd2l0aCBhIGZvcm11bGEgdGhhdCBzdGF5cyBsaW5rZWQgdG8gdGhlIHNvdXJjZS4%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_TRANSPOSE(array)%2Cp_Ii9mdW5jdGlvbnMvdHJhbnNwb3NlIg%2Cs_A5x36o_-f3LzwGhg.png" "og:image:height": "600" "og:image:type": image/png "og:image:width": "1200" "og:title": "TRANSPOSE function in Excel: syntax and examples | PracticeExcel" "twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~VFJBTlNQT1NFIGZ1bmN0aW9uIGluIEV4Y2VsOiBzeW50YXggYW5kIGV4YW1wbGVz%2Cdescription_~SG93IHRvIHVzZSBUUkFOU1BPU0UgaW4gRXhjZWwgYW5kIEdvb2dsZSBTaGVldHM6IHR1cm4gcm93cyBpbnRvIGNvbHVtbnMgd2l0aCBhIGZvcm11bGEgdGhhdCBzdGF5cyBsaW5rZWQgdG8gdGhlIHNvdXJjZS4%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_TRANSPOSE(array)%2Cp_Ii9mdW5jdGlvbnMvdHJhbnNwb3NlIg%2Cs_A5x36o_-f3LzwGhg.png" --- > Index of every page on this site: [llms.txt](https://practiceexcelonline.com/llms.txt) # **The TRANSPOSE function** Turns rows into columns and columns into rows. The result spills and stays linked to the original cells. = TRANSPOSE( ## **Syntax** ``` TRANSPOSE(array) ```
**array **
The range to flip.
## **Examples** F1=TRANSPOSE(A1:D2) | | A | B | C | D | E | F | G | | --- | --- | --- | --- | --- | --- | --- | --- | | 1 | Month | Jan | Feb | Mar | | **Month** | **Sales** | | 2 | Sales | 120 | 95 | 140 | | **Jan** | **120** | | 3 | | | | | | **Feb** | **95** | | 4 | | | | | | **Mar** | **140** | C1=TRANSPOSE(A1:A3) | | A | B | C | D | E | | --- | --- | --- | --- | --- | --- | | 1 | Ann | | **Ann** | **Ben** | **Cy** | | 2 | Ben | | | | | | 3 | Cy | | | | | ## **Questions**
### What is the difference between TRANSPOSE and Paste Special > Transpose? Paste Special flips a copy once, and later changes to the source do not follow. The TRANSPOSE function stays linked, so the flipped table updates when the original does.
### How do I use TRANSPOSE in older versions of Excel? Select the target range first, with the rows and columns swapped, type =TRANSPOSE(A1:D2) and press Ctrl+Shift+Enter. Excel 365 and Google Sheets spill the result by themselves.
## **Related functions** - [**SORT**](https://practiceexcelonline.com/functions/sort) - [**INDEX**](https://practiceexcelonline.com/functions/index) - [**SEQUENCE**](https://practiceexcelonline.com/functions/sequence) ```json {"@context":"https://schema.org","@graph":[{"@id":"https://practiceexcelonline.com/#identity","@type":"Organization","name":"PracticeExcel","url":"https://practiceexcelonline.com/","logo":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/#website","@type":"WebSite","inLanguage":"en-US","name":"PracticeExcel","url":"https://practiceexcelonline.com/","alternateName":["Practice Excel Online","PracticeExcelOnline.com"],"publisher":{"@id":"https://practiceexcelonline.com/#identity"},"workTranslation":{"@id":"https://excelopgaver.dk/#website"}},{"@id":"https://practiceexcelonline.com/functions/transpose#webpage","description":"How to use TRANSPOSE in Excel and Google Sheets: turn rows into columns with a formula that stays linked to the source.","name":"TRANSPOSE function in Excel: syntax and examples","url":"https://practiceexcelonline.com/functions/transpose","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/functions/transpose#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"mainEntity":[{"@id":"https://practiceexcelonline.com/functions/transpose#/schema/question/1"},{"@id":"https://practiceexcelonline.com/functions/transpose#/schema/question/2"}],"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/functions/transpose"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/functions/transpose#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Excel functions","item":"https://practiceexcelonline.com/functions","position":2},{"@type":"ListItem","name":"TRANSPOSE function in Excel: syntax and examples","position":3}]},{"@id":"https://practiceexcelonline.com/functions/transpose#article","description":"How to use TRANSPOSE in Excel and Google Sheets: turn rows into columns with a formula that stays linked to the source.","headline":"TRANSPOSE function in Excel: syntax and examples","inLanguage":"en-US","thumbnailUrl":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~VFJBTlNQT1NFIGZ1bmN0aW9uIGluIEV4Y2VsOiBzeW50YXggYW5kIGV4YW1wbGVz%2Cdescription_~SG93IHRvIHVzZSBUUkFOU1BPU0UgaW4gRXhjZWwgYW5kIEdvb2dsZSBTaGVldHM6IHR1cm4gcm93cyBpbnRvIGNvbHVtbnMgd2l0aCBhIGZvcm11bGEgdGhhdCBzdGF5cyBsaW5rZWQgdG8gdGhlIHNvdXJjZS4%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_TRANSPOSE(array)%2Cp_Ii9mdW5jdGlvbnMvdHJhbnNwb3NlIg%2Cs_A5x36o_-f3LzwGhg.png","@type":["Article","TechArticle"],"author":{"@id":"https://practiceexcelonline.com/#identity"},"image":{"@id":"https://practiceexcelonline.com/#/schema/image/1"},"isPartOf":{"@id":"https://practiceexcelonline.com/functions/transpose#webpage"},"mainEntityOfPage":{"@id":"https://practiceexcelonline.com/functions/transpose#webpage"},"publisher":{"@id":"https://practiceexcelonline.com/#identity"}},{"@id":"https://practiceexcelonline.com/functions/transpose#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"What is the difference between TRANSPOSE and Paste Special > Transpose?","acceptedAnswer":{"@type":"Answer","text":"Paste Special flips a copy once, and later changes to the source do not follow. The TRANSPOSE function stays linked, so the flipped table updates when the original does."}},{"@id":"https://practiceexcelonline.com/functions/transpose#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"How do I use TRANSPOSE in older versions of Excel?","acceptedAnswer":{"@type":"Answer","text":"Select the target range first, with the rows and columns swapped, type =TRANSPOSE(A1:D2) and press Ctrl+Shift+Enter. Excel 365 and Google Sheets spill the result by themselves."}},{"@id":"https://practiceexcelonline.com/#logo","@type":"ImageObject","caption":"PracticeExcel","contentUrl":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png"},{"@id":"https://practiceexcelonline.com/#/schema/image/1","@type":"ImageObject","contentUrl":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~VFJBTlNQT1NFIGZ1bmN0aW9uIGluIEV4Y2VsOiBzeW50YXggYW5kIGV4YW1wbGVz%2Cdescription_~SG93IHRvIHVzZSBUUkFOU1BPU0UgaW4gRXhjZWwgYW5kIEdvb2dsZSBTaGVldHM6IHR1cm4gcm93cyBpbnRvIGNvbHVtbnMgd2l0aCBhIGZvcm11bGEgdGhhdCBzdGF5cyBsaW5rZWQgdG8gdGhlIHNvdXJjZS4%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_TRANSPOSE(array)%2Cp_Ii9mdW5jdGlvbnMvdHJhbnNwb3NlIg%2Cs_A5x36o_-f3LzwGhg.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~VFJBTlNQT1NFIGZ1bmN0aW9uIGluIEV4Y2VsOiBzeW50YXggYW5kIGV4YW1wbGVz%2Cdescription_~SG93IHRvIHVzZSBUUkFOU1BPU0UgaW4gRXhjZWwgYW5kIEdvb2dsZSBTaGVldHM6IHR1cm4gcm93cyBpbnRvIGNvbHVtbnMgd2l0aCBhIGZvcm11bGEgdGhhdCBzdGF5cyBsaW5rZWQgdG8gdGhlIHNvdXJjZS4%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_TRANSPOSE(array)%2Cp_Ii9mdW5jdGlvbnMvdHJhbnNwb3NlIg%2Cs_A5x36o_-f3LzwGhg.png"}]} ``` ## Sitemap See the full [sitemap](https://practiceexcelonline.com/sitemap.md) for all pages.