OK, I have a dump of some data from an excel spreadsheet which I am going to put into a MS Access database. However, I need to do some manipulation of the data and am unsure how best to do this. The two 'fields' in the spreadsheet I am interested in are ID and Title. The way I have received the data, the title has been split over multiple rows, each of which has the same ID number in and I need to create one row which has all the bits of the title added together.
As an example, ID 1234 might have a full title of 'This is a test document title only' and the spreadsheet I have received has the following rows:
1234 This is a
1234 test document
1234 title only
And I need to end up with one record saying:
1234 This is a test document title only
How could I go about this?
Thanks.
As an example, ID 1234 might have a full title of 'This is a test document title only' and the spreadsheet I have received has the following rows:
1234 This is a
1234 test document
1234 title only
And I need to end up with one record saying:
1234 This is a test document title only
How could I go about this?
Thanks.
