Combine fields with the same ID into one

[bdabya]

I posted a question not to long ago on the same subject, but I was having one heck of a time wording it correctly. Let's just say I have a simple table with 2 fields: Parcel ID's and Legal Descriptions. The ID's look something like this (very simplified)

ID LegalDescriptions

1 Line one of description for id 1
1 line two of description for id 1
1 line three of description for id 1
1 etc for id 1
1 etc for id 1
2 Line one of description for id 2
2 line two of description for id 2
2 line three of description for id 2

and it continues for 64,000 records. It looks to me like the file was a simple spreadsheet that someone put together and thought it was a table. That is how I received it and I need to have it be ID 1 with one long line of legal description! I sure hope this is a common problem, but I'm not holding my breath. Thanks for any help you can offer!

 

[LarryDeLaruelle]

bdabya:

Are you experienced with VBA?

If so, you can create a sub that will read in each record and concantenate all of the descriptions for all the IDs of the same value and write a one line record to a new table.

Don't think there is a way to do this without using code.

If you haven't had any/much experience with VBA, let me know and I can probably help you put something together. Larry De Laruelle
ldelaruelle@familychildrenscenter.org