These are bird survey records. Each row is a species, each column is a different survey. So, with 100 different species and 50 different surveys, there are 50 data points for each species, the data point being the number of individuals of that species seen on that survey, and they are all on a single line (row), yielding a data range of 100 X 50 cells. I need to convert to a database format in which each data point is on a separate line (row). This will yield a data range of 5000 X 3 cells. The 3 column headings in this case would be species, number of birds, survey number, corresponding to the row heading, data point and column heading.
-----Original Message----- >From: Dan Lewis <[EMAIL PROTECTED]> >Sent: Nov 25, 2006 4:23 AM >To: [email protected] >Subject: Re: [users] database-style spreadsheet > >On Friday 24 November 2006 09:54 pm, Lisa Hardy wrote: >> Is there a simple way to convert data in a spreadsheet into >> "database-style", i.e., one record per line? I have several >> spreadsheets with multiple records per line. All I need is a way to >> create a new spreadsheet with every value in a given range of the >> original returned on a single line along with its row and column >> headings. This seems like something that people would need to do >> quite often... >> >> Any help appreciated, >> Lisa Hardy > > Possibly there is a way to do this, but what you wrote does not >make any sense. Could you give a simple example of what you mean? I >have no I idea of what you mean by a spreadsheet with multiple >records per line. Do you have more than one column with the same >name? Would moving some of these records create additional rows >containing just headings? It is impossible to visualize what you want >without more information. > >Dan > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
