Thanks to this little JS source-block snippet, I could simply rotate a 3 rows table into a 3 column table.
JS because I have no clue how to achieve the same with e-lisp.My real world problem had waaaaay more columns, hence the need to automate the thing!
#+name: data_table
タイトル1 | タイトル2 | タイトル3 | タイトル4 |
Title1 | Title2 | Title3 | Title4 |
123 | 456 | 789 | 546 |
#+BEGIN_SRC js :var data=data_table :results table :exports both
var output = [];
for(var column=0; column<data[0].length; ++column) {
output.push( [ data[0][column], data[1][column], data[2][column] ] );
}
return output;
#+RESULTS:
タイトル1 | Title1 | 123 |
タイトル2 | Title2 | 456 |
タイトル3 | Title3 | 789 |
タイトル4 | Title4 | 546 |