Hi b.franze,
You can put your script to the "Script Panel" of a (3-column) worksheet (right-click in the gray area in the worksheet, and choose "Show Script Panel" shortcut), then save it as a worksheet template. Sample script may be like as follows:
delete col(3);
delete col(2);
worksheet -a 2;
range c1=col(1);
range c2=col(2);
range c3=col(3);
nr=c1.getSize(); //number of rows
range r1=col(1)[1:$(nr/2)]; //1st half
range r2=col(1)[$(nr/2+1):nr]; //2nd half
c2=r1; //copy 1st harf
c3=r2; //copy 2nd half
When you open this template from the Template Library, the Script Panel with the code should appear. If you enter the data in the first column, and press "Execute All" button in the panel, it performs accordingly. (Note: Be aware that the bottom part of the data doesn't contain rows of missing values.)
Hope this helps.
--Hideo Fujii
OriginLab
