* Lisa Hardy <[EMAIL PROTECTED]> [251106, 18:52]:
> 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
[cut]
Hi Lisa,
May be there is a more elegant and quicker way to do what you need;
however, just in case no expert comes out with a better solution, I
would suggest that have a look at the 'past special' option 'transpose'.
As the name indicates, the data of the raw will be 'trasposed' as columns:
but then you will have to delete the redundant columns that the
transposition causes.
HTH
Regards,
Ennio.
--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (°|°)
[Why use Win$ozz (I say) if ... "even a fool can do that. )=(
Do something you aren't good at!" (as Henry Miller used to say) ]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
