{"id":47,"date":"2013-09-10T08:22:51","date_gmt":"2013-09-10T06:22:51","guid":{"rendered":"http:\/\/project40.de\/?p=47"},"modified":"2013-09-10T08:22:51","modified_gmt":"2013-09-10T06:22:51","slug":"transponieren-von-grossen-datenmengen","status":"publish","type":"post","link":"http:\/\/project40.de\/?p=47","title":{"rendered":"Transponieren von gro\u00dfen Datenmengen"},"content":{"rendered":"<p>Falls man mal mehr transponieren muss als Excel zul\u00e4sst.<\/p>\n<p><code>Sub transponieren()<\/p>\n<p>For intRow = 1 To 100<br \/>\n    Sheets(\"Tabelle1\").Cells(intRow, 1).Copy<br \/>\n    Sheets(\"Tabelle2\").Cells(1, intRow).Select<br \/>\n    ActiveSheet.Paste<br \/>\nNext intRow<\/p>\n<p>End Sub<br \/>\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Falls man mal mehr transponieren muss als Excel zul\u00e4sst. Sub transponieren() For intRow = 1 To 100 Sheets(&#8222;Tabelle1&#8220;).Cells(intRow, 1).Copy Sheets(&#8222;Tabelle2&#8220;).Cells(1, intRow).Select ActiveSheet.Paste Next intRow End Sub<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1,4,5],"tags":[],"_links":{"self":[{"href":"http:\/\/project40.de\/index.php?rest_route=\/wp\/v2\/posts\/47"}],"collection":[{"href":"http:\/\/project40.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/project40.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/project40.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/project40.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=47"}],"version-history":[{"count":1,"href":"http:\/\/project40.de\/index.php?rest_route=\/wp\/v2\/posts\/47\/revisions"}],"predecessor-version":[{"id":48,"href":"http:\/\/project40.de\/index.php?rest_route=\/wp\/v2\/posts\/47\/revisions\/48"}],"wp:attachment":[{"href":"http:\/\/project40.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=47"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/project40.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=47"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/project40.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=47"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}