|
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 |
 |
|
Taking subgroups of data
