Ask Your Question

Split specific rows to a 2nd sheet in Calc

asked 2017-03-19 07:12:21 +0200

rossnixon gravatar image

I have some running distances (3.5km, 5km, 7km) in a column. In a second column I have my time for each run. In a third column I use a formula to calculate average running speed.

How do I copy all the 3.5km rows to a second sheet? I'll then do similar for other distances - third sheet etc.

My purpose is to graph the increase in speed over time, for each distance. Oh, I do have a date column also, for the graph's X-axis.

edit retag flag offensive close merge delete


Its almost a bad idea to split these data into several sheets. Let it as flat list with only three Columns for

Date | Distance | Time

For the analysis you need only one instance of DataPilot and one Diagram based on DataPilot-output.

karolus gravatar imagekarolus ( 2017-03-19 11:25:02 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-03-19 07:25:12 +0200

pierre-yves samyn gravatar image


  • Create the second sheet (if it is not already)
  • Select the data range then DataMore FiltersStandard Filter
  • Field Name: select the running distances column, Condition: =, Value: select 3.5
  • Options▸Tick Copy results to and use the "shrink" tool to select the target.


edit flag offensive delete link more


Thanks, but I'm stuck on the "shrink" tool. I get a white box - how do I specify or select my 2nd sheet (which I named 3.5km)?

[EDIT: Ah, working now, after I clicked into the top-left cell of the 2nd sheet. that shows $'3.5km'.$A$1 ]

rossnixon gravatar imagerossnixon ( 2017-03-19 07:58:06 +0200 )edit
Login/Signup to Answer

Question Tools



Asked: 2017-03-19 07:12:21 +0200

Seen: 126 times

Last updated: Mar 19 '17