re-organizing data in spreadsheet

[Kenny]

I have a large amount of data in an excel spreadsheet
which needs to be "re-organized". Each observation uses
several rows and therefore makes the spreadsheet
impossible for me to import into other database
programs. I need to consolidate the data for each
observation into one row, with one column for each
variable. I have figured out how to do this using the
simple macro technique, but I can't figure out how to run
the macro on the entire spreadsheet all at once.
Otherwise I have to execute the macro on each observation
seperately, which is obviously unacceptable as there are
thousands of observations. Someone please help me, or
atleast refer me to the proper forum.

Thanks,
Kenny
(e-mail address removed)

 

[acw]

Kenny

There are a variety of looping methods and cell
redirection techniques. What combination you use depends
on the data layout and personal preference.

Have a look at While - Wend loops which will continue
until a cell is blank (use the isempty function). You can
nominate the next cell by the activecell.offset(row,
column) selection, or cells(row,col) technique.

It may help to see the layout of your data to provide
further advice.

Tony