{"id":10426,"date":"2022-11-11T17:48:05","date_gmt":"2022-11-11T16:48:05","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=10426"},"modified":"2022-11-12T18:39:44","modified_gmt":"2022-11-12T17:39:44","slug":"excel-transposer-une-plage-de-cellules","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=10426","title":{"rendered":"Excel : transposer une plage de cellules"},"content":{"rendered":"<p style=\"text-align: justify;\">Transposer (ou pivoter) une plage de cellules consiste \u00e0 intervertir les donn\u00e9es en colonnes et en cellules.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10427\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/EXCEL-TRANSPOSE.png\" alt=\"EXCEL TRANSPOSE\" width=\"599\" height=\"261\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/EXCEL-TRANSPOSE.png 599w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/EXCEL-TRANSPOSE-300x131.png 300w\" sizes=\"auto, (max-width: 599px) 100vw, 599px\" \/>Cette op\u00e9ration est r\u00e9alis\u00e9e gr\u00e2ce \u00e0 la fonction TRANSPOSE(plage).<\/p>\n<p style=\"text-align: justify;\">Dans l&#8217;exemple ci-avant, la <strong>fonction TRANSPOSE<\/strong> pivote les donn\u00e9es de la plage s\u00e9lectionn\u00e9e (ici A1:C6) dans la cellule o\u00f9 est situ\u00e9e la formule de calcul et celles adjacentes.<\/p>\n<p style=\"text-align: justify;\">Les effets de cette fonction sont identiques au <a href=\"https:\/\/www.auditsi.eu\/?p=6065\">collage sp\u00e9cial Transpos\u00e9<\/a>.<\/p>\n<p style=\"text-align: justify;\">___<\/p>\n<p style=\"text-align: justify;\">Approfondir le sujet : <a href=\"https:\/\/www.auditsi.eu\/?cat=2765\">Analyse de donn\u00e9es et automatisation<\/a> \/ <a href=\"https:\/\/www.auditsi.eu\/?glossary=excel\">Tout savoir sur Excel<\/a>&nbsp;\/&nbsp;<a title=\"S\u00e9rie d'articles Ma\u00eetriser Excel\" href=\"https:\/\/www.auditsi.eu\/?p=4475\">D\u00e9couvrir la s\u00e9rie d\u2019articles Ma\u00eetriser Excel<\/a><\/p>\n<div id=\"sconnect-is-installed\" style=\"display: none; text-align: justify;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Excel%20%3A%20transposer%20une%20plage%20de%20cellules\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Transposer (ou pivoter) une plage de cellules consiste \u00e0 intervertir les donn\u00e9es en colonnes et en cellules. Cette op\u00e9ration est r\u00e9alis\u00e9e gr\u00e2ce \u00e0 la fonction TRANSPOSE(plage). Dans l&#8217;exemple ci-avant, la fonction TRANSPOSE pivote les donn\u00e9es de la plage s\u00e9lectionn\u00e9e (ici A1:C6) dans la cellule o\u00f9 est situ\u00e9e la formule de calcul et celles adjacentes. Les &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=10426\" class=\"more-link\">Continue reading &lsquo;Excel : transposer une plage de cellules&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Excel%20%3A%20transposer%20une%20plage%20de%20cellules\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[1326],"tags":[1633,2770,2769,2771],"class_list":["post-10426","post","type-post","status-publish","format-standard","hentry","category-maitriser-excel","tag-excel","tag-pivoter","tag-transpose","tag-transposer"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10426","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10426"}],"version-history":[{"count":5,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10426\/revisions"}],"predecessor-version":[{"id":10429,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10426\/revisions\/10429"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10426"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10426"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10426"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}