{"id":4233,"date":"2015-09-09T15:18:09","date_gmt":"2015-09-09T13:18:09","guid":{"rendered":"https:\/\/www.itlektor.cz\/?p=4233"},"modified":"2021-11-11T17:42:02","modified_gmt":"2021-11-11T16:42:02","slug":"transpozice-tabulky","status":"publish","type":"post","link":"https:\/\/www.itlektor.cz\/en\/transpozice-tabulky\/","title":{"rendered":"Table transpose"},"content":{"rendered":"

<\/p>\n

Do you have wrong direction of a table and you do not want to rewrite the cells from a column in a row? Use a simple trick and Excel will do all that is necessary. Read in this manual, what needs to be done. If this guide has helped you, become a fan on Facebook<\/a> and recommend this site to your friends, it\u00a0can be useful for them too.<\/p>\n

Transpose<\/h2>\n

It may be the case that we have filled the cells next to each other (in a row) and for some reason we want to have them below each other\u00a0(in the column), or vice versa. Similarly, we want to overturn the whole table of 90 degrees, swap rows and columns<\/strong>. Row\u00a0tables (with headlines for individual lines) are for Excel in many cases useless, because they do not support for example filtering or creating pivot tables. Therefore, in\u00a0is\u00a0suitable to\u00a0change\u00a0the table into columnar form.<\/p>\n

All the above situations can be achieved by method “transposition”. Apply this procedure:<\/p>\n

    \n
  1. Select the area you need to overturn.<\/li>\n
  2. Make a Copy command (via CTRL+C).<\/li>\n
  3. Click into the empty cell, from which to begin to fill the transposed\u00a0region.<\/li>\n
  4. Make a Paste Special > Transpose<\/strong>.<\/li>\n
  5. Finish\u00a0Copy mode by pressing Escape<\/li>\n<\/ol>\n

    See the entire procedure at the animation below.<\/p>\n

    \"Transpozice\"<\/a>
    Transpozice<\/figcaption><\/figure>\n

    TRANSPOSE function<\/h2>\n

    In some cases, we work with a formulas from wrong oriented areas, which must be for the correct calculation also reversed. It is not necessary to transpose the area using the above procedure, the calculation can only rotate the\u00a0region using special function Transpose. With this feature, we work\u00a0in “array” formulas.<\/p>\n

    =TRANSPOSE(field)<\/p>\n

      \n
    • field\u00a0… range of cells you want to transpose<\/li>\n<\/ul>\n

      The result of the TRANSPOSE function\u00a0is an area of several cells, and is always overturned about 90 degrees from its original location. However, the transfer is done only\u00a0for the purposes of calculation and therefore nothing visible happens.<\/p>\n

      <\/p>\n","protected":false},"excerpt":{"rendered":"

      Do you have wrong direction of a table and you do not want to rewrite the cells from a column in a row? Use a simple trick and Excel will do all that is necessary. Read in this manual, what needs to be done. If this guide has helped you, become a fan on Facebook […]<\/p>\n","protected":false},"author":1,"featured_media":4237,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[3],"tags":[10,49,58,50],"_links":{"self":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/4233"}],"collection":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/comments?post=4233"}],"version-history":[{"count":0,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/4233\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media\/4237"}],"wp:attachment":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media?parent=4233"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/categories?post=4233"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/tags?post=4233"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}