{"id":1627,"date":"2017-02-09T09:26:25","date_gmt":"2017-02-09T17:26:25","guid":{"rendered":"http:\/\/www.auval.com.mx\/notas\/?p=1627"},"modified":"2017-02-09T09:26:25","modified_gmt":"2017-02-09T17:26:25","slug":"como-reacomodar-valores-usando-vlookup-buscarv","status":"publish","type":"post","link":"https:\/\/auval.com.mx\/blog\/2017\/02\/09\/como-reacomodar-valores-usando-vlookup-buscarv\/","title":{"rendered":"C\u00f3mo reacomodar valores usando VLOOKUP \/ BUSCARV"},"content":{"rendered":"<p>PREGUNTA DE DANIEL RODR\u00cdGUEZ<\/p>\n<p>Tengo un archivo que contiene datos en vertical y quiero pasarlos a horizontal, este es un ejemplo de como los tengo:<\/p>\n<p>1051, Categoria A, BRP6EY<br \/>\n1051, Categoria B,BKR6EGP<br \/>\n1051, Categoria C,BKR6EIX<br \/>\n1051, Categoria D,21002<\/p>\n<p>y quiero que quede as\u00ed:<\/p>\n<p>id\u2502Categoria A\u2502Categoria B\u2502Categoria C\u2502Categoria D<br \/>\n1051\u2502BRP6EY\u2502BKR6EGP\u2502BKR6EIX\u250221002<\/p>\n<p>&nbsp;<\/p>\n<p>RESPUESTA<\/p>\n<p>Se puede hacer con un VLOOKUP \/ BUSCARV. Aqu\u00ed anexo un video.<\/p>\n<p><iframe loading=\"lazy\" title=\"C\u00f3mo usar BUSCARV para reacomodar valores\" width=\"605\" height=\"340\" src=\"https:\/\/www.youtube.com\/embed\/EJyJ-lxPHM8?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>PREGUNTA DE DANIEL RODR\u00cdGUEZ Tengo un archivo que contiene datos en vertical y quiero pasarlos a horizontal, este es un ejemplo de como los tengo: 1051, Categoria A, BRP6EY 1051, Categoria B,BKR6EGP 1051, Categoria C,BKR6EIX 1051, Categoria D,21002 y quiero &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"more-link\" href=\"https:\/\/auval.com.mx\/blog\/2017\/02\/09\/como-reacomodar-valores-usando-vlookup-buscarv\/\"> <span class=\"screen-reader-text\">C\u00f3mo reacomodar valores usando VLOOKUP \/ BUSCARV<\/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":[2],"tags":[],"class_list":["post-1627","post","type-post","status-publish","format-standard","hentry","category-excel"],"_links":{"self":[{"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/posts\/1627","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=1627"}],"version-history":[{"count":0,"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/posts\/1627\/revisions"}],"wp:attachment":[{"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/media?parent=1627"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/categories?post=1627"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/auval.com.mx\/blog\/wp-json\/wp\/v2\/tags?post=1627"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}