{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Beispiel Start","Load_Data_Here","omkantine.de"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Beispiel Start","index":0,"n_rows":12,"n_cols":18,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,16,11,17]]}
["Konto","Kontobezeichnung","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Total",null,"Makro Werte für dieses Beispiel:"]
[233,"Petty Cash",12,15,13,11,12,16,17,15,12,11,8,9,{"$f":"SUM(C2:N2)","v":151},null,"Fragen","Input"]
[251,"Kasse I",0,0,0,0,0,4,5,6,7,7,11,12,{"$f":"SUM(C3:N3)","v":52},null,"Frage 1 - Start:","D"]
[266,"Kasse II",2,1,1,1,4,5,4,7,6,2,2,3,38,null,"Frage 2 - Nach","C"]
[298,"Bank",26,24,21,27,27,29,24,24,21,23,24,27,297,null,"Frage 3 - Wie oft",11]
[299,"Transit",0,1,1,1,2,1,2,0,0,0,1,1,10,null,"Frage 4 - Ab","A"]
[400,"Umsatz",45,39,54,51,48,47,52,42,39,38,45,46,546,null,"Frage 5 - Bis","B"]
[500,"Kosten",22,17,26,24,21,22,25,19,16,16,21,22,251,null,"Frage 6 - Dimension neu","Monat"]
[600,"Marketing",2,3,6,9,3,2,1,2,3,5,6,2,44,null,"Frage 7 - Wertespalte","Saldo"]
[700,"Personal",10,10,10,10,10,10,10,12,12,12,12,12,130]
[800,"Sonstige",1,1,2,1,1,2,1,1,2,1,1,1,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Das Makro kopiert mit diesen Angaben alle Werte von Februar bis Dezember in die Januar Spalte. Zwischen B und C wird eine Spalte eingefügt. In die neue Spalte wird der jeweilige Monat geschrieben (Jan bis Dec). Die Zeilenbeschriftungen aus A und B werden in jedem Monat wiederholt. Aus einer 11 x 14 Tabelle wird also eine 121 x 4 Tabelle."]

{"sheet":"Load_Data_Here","index":1,"n_rows":11,"n_cols":16,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Konto","Kontobezeichnung","monat","saldo","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Total"]
[233,"Petty Cash","Jan",12,15,13,11,12,16,17,15,12,11,8,9,{"$f":"SUM(D2:O2)","v":151}]
[251,"Kasse I","Jan",0,0,0,0,0,4,5,6,7,7,11,12,{"$f":"SUM(D3:O3)","v":52}]
[266,"Kasse II","Jan",2,1,1,1,4,5,4,7,6,2,2,3,38]
[298,"Bank","Jan",26,24,21,27,27,29,24,24,21,23,24,27,297]
[299,"Transit","Jan",0,1,1,1,2,1,2,0,0,0,1,1,10]
[400,"Umsatz","Jan",45,39,54,51,48,47,52,42,39,38,45,46,546]
[500,"Kosten","Jan",22,17,26,24,21,22,25,19,16,16,21,22,251]
[600,"Marketing","Jan",2,3,6,9,3,2,1,2,3,5,6,2,44]
[700,"Personal","Jan",10,10,10,10,10,10,10,12,12,12,12,12,130]
[800,"Sonstige","Jan",1,1,2,1,1,2,1,1,2,1,1,1,15]

{"sheet":"omkantine.de","index":2,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Blog Artikel:"]
[null,"http://www.omkantine.de/excel-makro-mehrere-datenspalten-in-einer-spalte-zusammenfuehren/"]
[]
[null,"Download:"]
[null,"http://www.omkantine.de/attachments/Columndata_Collect.xlsm"]