{"id":333,"date":"2014-04-25T19:51:36","date_gmt":"2014-04-25T17:51:36","guid":{"rendered":"http:\/\/people.unil.ch\/jacquelinefrey\/?p=333"},"modified":"2022-08-09T14:56:43","modified_gmt":"2022-08-09T12:56:43","slug":"excel-transposer-des-donnees-2","status":"publish","type":"post","link":"https:\/\/people.unil.ch\/jacquelinefrey\/2014\/04\/excel-transposer-des-donnees-2\/","title":{"rendered":"Excel &#8211; Transposer des donn\u00e9es"},"content":{"rendered":"<p><strong>Contexte<\/strong><\/p>\n<p>Vous avez cr\u00e9\u00e9 un tableau Excel contenant des en-t\u00eates (Libell\u00e9, Quantit\u00e9, Prix unitaire, Total&#8230;) et vous avez saisi de multiples valeurs dans le tableau ainsi que des formules de calcul. Apr\u00e8s plusieurs heures de saisie, vous constatez que la structure de votre tableau n&rsquo;est pas ad\u00e9quate. En effet, votre tableau doit \u00eatre \u00ab\u00a0retourn\u00e9\u00a0\u00bb car vous souhaitez que les en-t\u00eates de colonnes deviennent des en-t\u00eates de lignes. Bien entendu, les donn\u00e9es saisies et les formules de calcul doivent absolument \u00ab\u00a0suivre\u00a0\u00bb lors de ce grand chamboulement.<\/p>\n<p>Deux possibilit\u00e9s s&rsquo;offrent \u00e0 vous : 1\u00b0 vous passez un week-end ensoleill\u00e9 \u00e0 faire du \u00ab\u00a0couper-coller\u00a0\u00bb ou 2\u00b0 vous transposez votre tableau Excel en 30 secondes en attendant que votre caf\u00e9 refroidisse un peu.&nbsp; Je ne vous explique donc pas dans cet article comment faire du \u00ab\u00a0couper-coller\u00a0\u00bb mais comment faire une transposition.<\/p>\n<p><strong>Solution<\/strong><\/p>\n<ul>\n<li>S\u00e9lectionnez votre tableau (en-t\u00eates de colonnes, donn\u00e9es et calculs)<\/li>\n<li>Appuyez sur Cmd + C (bah oui, quand m\u00eame)<\/li>\n<li>Dans l&rsquo;onglet Accueil, cliquez sur le menu contextuel du bouton Coller<\/li>\n<li>Choisissez Collage Sp\u00e9cial et cochez l&rsquo;option Transpos\u00e9<\/li>\n<li>C&rsquo;est tout&#8230;<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contexte Vous avez cr\u00e9\u00e9 un tableau Excel contenant des en-t\u00eates (Libell\u00e9, Quantit\u00e9, Prix unitaire, Total&#8230;) et vous avez saisi de multiples valeurs dans le tableau ainsi que des&hellip;<\/p>\n","protected":false},"author":83,"featured_media":3355,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"template-full-width-cover.php","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","footnotes":""},"categories":[4],"tags":[54],"class_list":{"0":"post-333","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-excel","8":"tag-collage-special"},"_links":{"self":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/333","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/users\/83"}],"replies":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/comments?post=333"}],"version-history":[{"count":0,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/333\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media\/3355"}],"wp:attachment":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media?parent=333"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/categories?post=333"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/tags?post=333"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}