Antsmarching.org Forums - Dave Matthews Band Discussion - View Single Post - Roger’s Excel Thread
View Single Post
Old 03-03-2006, 10:35 AM   #18
PrettyPenelope
 
Join Date: Mar 2004
Location: Los Angeles, CA
Posts: 1,455

Shows Seen: 48

DMB Hub Stubs: 14

My Tour Central Stats

Re: Excel Help

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.
__________________

PrettyPenelope is offline   Reply With Quote