On this layout, does each row of data represent a different record (It should) or did you use a different set of fields for every row?
And how does this need to look in your spread sheet?
What we are trying to do is, in Filemaker Pro, have each individual test subject represent a record and then export that individual data to Excel into group records. If we have 5 groups with 5 test subjects (hypothetical numbers), we would have 25 sheets of data in Filemaker Pro but can export that weekly data into 5 Excel group sheets. There we can average the data (such as weight gain/loss and tumor growth) for the 5 test subjects into just that 1 test group. Basically, what I am hoping is that I can just export from our template and route it to an Excel template of some kind for an easy transfer.
I'm trying to get an upload of what the export looks like when I do it. When I do, I can post it for you. It is basically lining up all of the headers across the top and telling me that it can only take the first line of data in the export denoting the first test subject's data.
I don't want what it looks like, I want to see what you need to get when you get the data into the actual spread sheet.
I take that your screen shot is of a single record? If so, this is a design that will make your export of the data difficult. Breaking this data up into individual records will make it much easier to work with--both in exporting and within your Filemaker database. This can be done and you can still get the layout you have posted in this thread to work for you.