consolidating data from many rows per subject into medians and means per variable in a single row

Hi gang,

I have 64 rows of measurement data (reaction time, decision accuracy, memory recall accuracy) for 30+participants with 3 manipulated test variables (high/low, 1/2/3/4, difficult/medium).  This gives me over 2000 rows of data.   The cells contain a mix of time values that measure a reaction speed and binary values that compare an answer to truth data.  They also contain some demographic data that are consistent across all rows for that participant.

Could you please walk me through how to establish a function(s) to consolidate my data into a single row for each subject in a separate worksheet capturing median for the time variables and % correct for the binary variables? 

Output I am looking for is one summary row for each participant with a single consolidated value for each of the test variables (e.g. response time mean for Low, response time mean for 1, etc).

Many thanks,

Simon