concatenating from multiple records

[mjfmn]

I have a table similar to this example:
ID Sequence Description
100 1 Left
100 2 Right
100 3 Up
100 4 Down
200 1 Top
200 2 Bottom
300 1 Inside
400 1 Outside
400 2 Downside

There are about 50,000 records. What I'm trying to do is concatenate all the descriptions for one ID into one field in the sequence 1 record. So when it was done, and I sorted by ID then sequence (and only used sequence 1 records), I would have something like
ID Sequence Description
100 1 Left Right Up Down
200 1 Top Bottom
300 1 Inside
400 1 Outside Downside

I know I can use the &" "& to add fields together, but I would like to find a way I could automate this instead of going line by line for thousands of records. Can this be accomplished in Excel? Thank you for your responses!
Mike

[StephenR]

Try this:

Please Login or Register  to view this content.

[mjfmn]

B R I L L I A N T! Simply brilliant! I never could have come up with something so complex! I can't thank you enough, you even had it remove the records that I didn't need! Perhaps I'll need to start boning up on my vb language skills as well! Thanks again!
Mike