Quote:
Originally Posted by MacGuyver
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??
|
I would try making a copy of the sheet, and save it under another name so it doesn't affect the original. Then do a sort according to whatever column you want, so that all the lines with actual words/numbers will appear together at the top, and the blank lines below. Hope that helps.