I have a new problem, hopefully people will help me out.
I have a spreadsheet, with one value every 15 rows. so cells A1 - A14 are blank, and A15 has a value.
then cells A16 to A29 are blank, and A30 has a value.
and so on. this continues on for about 4000 rows. the values represent an average of 15 values.
my question is:
I need to plot a graph of these values (they are chemical concentrations if that matters) vs time. Thus, I need to make a table. Is there a way to transfer these values, that are spaced apart by 14 rows, into a table so that they are one below the other?
I've tried some formulas and excel doesn't seem to be picking them up.
I KNOW! Macguyver stumped. who'd of thunk??