I have a list of methods for the analysis of water quality parameters,
each with a long detailed description. Somewhere before this data made
its way to me, the long descriptions were parsed into multiple cells in
the same column, and numbered in the adjacent column to the left to
indicate the order in which they would have to be put back together.
These groups range from 2 to 30 cells. I have about 14,500 records to
go through and have been trying to build a macro, either in Excel of
Acess, that will recognize that when this number goes back to 1, all
cells in the column to the right of it (description column) need to be
concatenated, up until the next 1 is reached. Each cluster has a unique
ID as well, sequentially increasing in increments of 1. This could be
another option for the macro: whenever this number increases, the
concatenation begins, then ends before the next increase. I have
limited experience with VBA and am having trouble putting this
together.

Anyone have any ideas?


--
MikeM
------------------------------------------------------------------------
MikeM's Profile: http://www.excelforum.com/member.php...o&userid=35502
View this thread: http://www.excelforum.com/showthread...hreadid=552694