With 50k records this might get tedious, but here's an
approach that does not require coding.

Sort the dataset on col 1. For each block of repeated
names use "&" to tack the cell contents together. Put the
formulas in, say col 8. You would have two types of
formula:

Start of block: col 1 & col2 & ... & col 7
Subsequent rows: (previous row)col 8 & col2 & ... & col 7

If this is a once-off, this might be the easiest approach
with the judicious use of fill-down. If you expect to do
this more than once on different datasets, you might try
coding it. Either way, using Excel's sort and & will
likely help.

Tony


-----Original Message-----
.....

For example:

country year note1 etc...
France 1990 abcd
England 1991 abcd
France 1994 1234
France 1993 aaaa
England 1992 1234
USA 2000 bbbb

becomes cacatenated as:

France 1990 abcd 1994 1234 1993 aaaa etc.
England 1991 abcd 1992 1234 etc.
USA 2000 bbbb

Thanks in advance.

Matthew Kramer


*** Sent via Developersdex http://www.developersdex.com
***
.