{"id":1612,"date":"2016-11-10T09:22:34","date_gmt":"2016-11-10T17:22:34","guid":{"rendered":"http:\/\/www.auval.com.mx\/notas\/?p=1612"},"modified":"2016-11-10T09:22:34","modified_gmt":"2016-11-10T17:22:34","slug":"pasar-de-vertical-a-horizontal-con-formulas","status":"publish","type":"post","link":"https:\/\/auval.com.mx\/blog\/2016\/11\/10\/pasar-de-vertical-a-horizontal-con-formulas\/","title":{"rendered":"Pasar de vertical a horizontal con f\u00f3rmulas"},"content":{"rendered":"<p>Me lleg\u00f3 esta pregunta interesante de Charlie:<\/p>\n<p>Hola, me gustar\u00eda me puedas ayudar con el siguiente ejemplo:<\/p>\n<p>ORIGEN DE LA BASE (MAS DE 100,000 CUENTAS)<\/p>\n<table>\n<tbody>\n<tr>\n<td>Cuenta<\/td>\n<td>telefono<\/td>\n<\/tr>\n<tr>\n<td>303321358<\/td>\n<td>6621392592<\/td>\n<\/tr>\n<tr>\n<td>303321358<\/td>\n<td>6621750138<\/td>\n<\/tr>\n<tr>\n<td>303321358<\/td>\n<td>6621814812<\/td>\n<\/tr>\n<tr>\n<td>303321358<\/td>\n<td>6622277041<\/td>\n<\/tr>\n<tr>\n<td>303315960<\/td>\n<td>6621029997<\/td>\n<\/tr>\n<tr>\n<td>303315960<\/td>\n<td>6621033846<\/td>\n<\/tr>\n<tr>\n<td>303315960<\/td>\n<td>6621191863<\/td>\n<\/tr>\n<tr>\n<td>303315960<\/td>\n<td>6621427012<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>RESULTADO REQUERIDO<\/p>\n<table>\n<tbody>\n<tr>\n<td>Cuenta<\/td>\n<td>TEL1<\/td>\n<td>TEL2<\/td>\n<td>TEL3<\/td>\n<td>TEL4<\/td>\n<\/tr>\n<tr>\n<td>303321358<\/td>\n<td>6621392592<\/td>\n<td>6621750138<\/td>\n<td>6621814812<\/td>\n<td>6622277041<\/td>\n<\/tr>\n<tr>\n<td>303315960<\/td>\n<td>6621029997<\/td>\n<td>6621033846<\/td>\n<td>6621191863<\/td>\n<td>6621427012<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Aqu\u00ed les dejo el video de c\u00f3mo se hace.<\/p>\n<p><iframe loading=\"lazy\" title=\"Poner horizontal una lista de datos en Excel\" width=\"605\" height=\"340\" src=\"https:\/\/www.youtube.com\/embed\/JXNuwd4epow?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Me lleg\u00f3 esta pregunta interesante de Charlie: Hola, me gustar\u00eda me puedas ayudar con el siguiente ejemplo: ORIGEN DE LA BASE (MAS DE 100,000 CUENTAS) Cuenta telefono 303321358 6621392592 303321358 6621750138 303321358 6621814812 303321358 6622277041 303315960 6621029997 303315960 6621033846 303315960 &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"more-link\" href=\"https:\/\/auval.com.mx\/blog\/2016\/11\/10\/pasar-de-vertical-a-horizontal-con-formulas\/\"> <span class=\"screen-reader-text\">Pasar de vertical a horizontal con f\u00f3rmulas<\/span> Leer m\u00e1s \u00bb<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1612","post","type-post","status-publish","format-standard","hentry","category-office"],"_links":{"self":[{"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/posts\/1612","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/comments?post=1612"}],"version-history":[{"count":0,"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/posts\/1612\/revisions"}],"wp:attachment":[{"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/media?parent=1612"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/categories?post=1612"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/tags?post=1612"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}