Hideo Fujii
USA
1582 Posts |
Posted - 06/21/2016 : 2:51:30 PM
|
Hi nahuelv,
Origin has the following "Reduce Rows" function, but unfortunately it is available from Origin version 9.1.
1) Choose "Worksheet: Reduce Rows" menu with the options like: Reduce Method = Reduce N rows with merged values Merge Rows = 200 Merge by = Sum
In an older version like yours, you can try the following:
1) In Set Column Values tool, use the following formula (when your data is in col(1), and output goes to col(2).) mod(i,200)==1?col(1)[i]:col(2)[i-1]+col(1)[i]
2) For the output column of 1), choose "Worksheet: Reduce Rows" menu with the following options: Reduce Method = Reduce N rows, then skip M rows Delete Rows = 199 Skip Rows = 1
Hope this helps.
--Hideo Fujii OriginLab
|
Edited by - Hideo Fujii on 06/21/2016 5:08:14 PM |
 |
|