{"id":6816,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/transpose\/"},"modified":"2021-02-26T08:15:23","modified_gmt":"2021-02-26T08:15:23","slug":"transpose","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/transpose\/","title":{"rendered":"TRANSPOSE"},"content":{"rendered":"

Description de la fonctionnalit\u00e9<\/h2>\n

La fonction TRANSPOSE<\/code> dans Excel et Google Sheets permet de pivoter ou de permuter des donn\u00e9es d’un tableau. Elle transforme les lignes d’une plage de cellules en colonnes et inversement. Cette fonction est essentielle pour r\u00e9organiser les donn\u00e9es de mani\u00e8re dynamique sans avoir \u00e0 les modifier manuellement.<\/p>\n

Syntaxe:<\/strong><\/p>\n

=TRANSPOSE(matrice)<\/code><\/pre>\n
O\u00f9 matrice<\/code> repr\u00e9sente la plage de cellules \u00e0 transposer.<\/p>\n
Exemples d’utilisation<\/h2>\n
Supposons que vous ayez un tableau avec des noms de produits en colonne et des donn\u00e9es associ\u00e9es en ligne, et que vous souhaitiez inverser l’orientation de ces donn\u00e9es.<\/p>\n
A B 1 Produit Quantit\u00e9 2 Pommes 30 3 Poires 20<\/code><\/pre>\n
Pour transposer cette plage, entrez la formule suivante dans une nouvelle cellule :<\/p>\n
=TRANSPOSE(A1:B3)<\/code><\/pre>\n
R\u00e9sultat de la transposition :<\/p>\n\n\n\n
Produit<\/td>\nPommes<\/td>\nPoires<\/td>\n<\/tr>\n
Quantit\u00e9<\/td>\n30<\/td>\n20<\/td>\n<\/tr>\n<\/table>\n
Sc\u00e9narios pratiques<\/h2>\n
Cr\u00e9ation d’un rapport r\u00e9sum\u00e9<\/h3>\n
Imaginez que vous disposiez des donn\u00e9es de vente mensuelles d\u2019une entreprise, list\u00e9es par produit dans chaque colonne et par mois en ligne. Pour faciliter les comparaisons mensuelles, vous souhaitez transposer ces donn\u00e9es.<\/p>\n
Avant d\u2019appliquer TRANSPOSE<\/code> :<\/p>\n
A B C D 1 Mois Produit1 Produit2 Produit3 2 Janvier 200 150 190 3 F\u00e9vrier 210 160 195<\/code><\/pre>\n
Formule \u00e0 utiliser :<\/p>\n
=TRANSPOSE(A1:D3)<\/code><\/pre>\n
R\u00e9sultat apr\u00e8s transposition :<\/p>\n\n\n\n\n\n
Mois<\/td>\nJanvier<\/td>\nF\u00e9vrier<\/td>\n<\/tr>\n
Produit1<\/td>\n200<\/td>\n210<\/td>\n<\/tr>\n
Produit2<\/td>\n150<\/td>\n160<\/td>\n<\/tr>\n
Produit3<\/td>\n190<\/td>\n195<\/td>\n<\/tr>\n<\/table>\n
Organisation des donn\u00e9es pour les graphiques<\/h3>\n
Vous poss\u00e9dez des donn\u00e9es recueillies pour diff\u00e9rentes cat\u00e9gories, qui sont arrang\u00e9es en colonnes, mais vous avez besoin de les pr\u00e9senter en lignes pour cr\u00e9er un graphique comparatif intuitif.<\/p>\n
Donn\u00e9es initiales :<\/p>\n
A B C 1 Cat\u00e9gorie 2016 2017 2 Cat1 500 600 3 Cat2 450 560<\/code><\/pre>\n
Utilisation de la fonction :<\/p>\n
=TRANSPOSE(A1:C3)<\/code><\/pre>\n
R\u00e9sultat obtenu :<\/p>\n\n\n\n\n
Cat\u00e9gorie<\/td>\nCat1<\/td>\nCat2<\/td>\n<\/tr>\n
2016<\/td>\n500<\/td>\n450<\/td>\n<\/tr>\n
2017<\/td>\n600<\/td>\n560<\/td>\n<\/tr>\n<\/table>\n
Ce tableau transpos\u00e9 peut d\u00e9sormais servir \u00e0 g\u00e9n\u00e9rer directement un graphique \u00e0 barres empil\u00e9es, offrant une vue claire et visuelle des \u00e9volutions par cat\u00e9gorie et par ann\u00e9e.<\/p>\n","protected":false},"excerpt":{"rendered":"
Renvoie la tRansposition d\u2019une matRice<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[312],"tags":[],"class_list":["post-6816","post","type-post","status-publish","format-standard","hentry","category-recherche-et-matrices"],"acf":[],"yoast_head":"\nFonction TRANSPOSE dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction TRANSPOSE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/fr\/transpose\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction TRANSPOSE dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction TRANSPOSE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/transpose\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:15:23+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction TRANSPOSE dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/transpose\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/transpose\/\",\"name\":\"Fonction TRANSPOSE dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:48+00:00\",\"dateModified\":\"2021-02-26T08:15:23+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction TRANSPOSE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/transpose\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/transpose\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/transpose\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Recherche et matrices\",\"item\":\"https:\/\/functiontranslator.com\/fr\/recherche-et-matrices\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"TRANSPOSE\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fonction TRANSPOSE dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction TRANSPOSE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","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:\/\/functiontranslator.com\/fr\/transpose\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction TRANSPOSE dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction TRANSPOSE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/transpose\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:15:23+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction TRANSPOSE dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/transpose\/","url":"https:\/\/functiontranslator.com\/fr\/transpose\/","name":"Fonction TRANSPOSE dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:48+00:00","dateModified":"2021-02-26T08:15:23+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction TRANSPOSE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/transpose\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/transpose\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/transpose\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Recherche et matrices","item":"https:\/\/functiontranslator.com\/fr\/recherche-et-matrices\/"},{"@type":"ListItem","position":3,"name":"TRANSPOSE"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6816","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/comments?post=6816"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6816\/revisions"}],"predecessor-version":[{"id":29825,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6816\/revisions\/29825"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6816"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6816"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6816"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}