Well, "transpose" appears to simply take an array of say, 10 X 20, and make it a 20 X 10. I believe my only solution is to write a routine to automate the process, or spend a couple of hours cutting, pasting, and copying.
Thanks for the suggestion, though. Lisa -----Original Message----- >From: Ennio-Sr <[EMAIL PROTECTED]> >Sent: Dec 1, 2006 7:42 AM >To: [EMAIL PROTECTED] >Subject: Re: [users] database-style spreadsheet > >Hi, Lisa, sorry to disturb you privately ... >I'm re-forwarding directly to you my answer (originally sent to >[EMAIL PROTECTED]) as I suspect you didn't see it and I'm curious to know >if that is a solution to your problem :-) > >---------------- > >* 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: users@openoffice.org >> >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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]