Split specific rows to a 2nd sheet in Calc

[rossnixon]

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.

[karolus]

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.

[PYS]

Hi

• Create the second sheet (if it is not already)
• Select the data range then Data▸More Filters▸Standard 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.

Regards

[rossnixon]

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 ]