Combine several records into one record

[Helge]

How can I combine several records in a table into one record?

Suppose that I have a table like Table1 in the attached image.
Then I want to combine all records with the same value for Key1 in one record.
The result is shown in Table2 in the attached image.

I would prefer to do it using SQL only, but I guess that this is not possible. Is it possible?
Alternatively I could accept to turn to VBA that could do it. Any good links about this?

 

[CJ_London]

Investigate using a crosstab query.

You'll need two crosstabs to do what you require plus a third to combine the results

Here is a link to tell you about Crosstabs

http://office.microsoft.com/en-gb/a...y-using-a-crosstab-query-HA010229577.aspx#BM2

 

[Helge]

Thank you for your answer, but I don't see how to do it. Could you please give details.

Investigate using a crosstab query.

You'll need two crosstabs to do what you require plus a third to combine the results
...

 

[Helge]

Hi CJ_London

After some tests in SQL I have decided to do it in VBA!
If you are interested in the VBA code, please send your e-mail address to hela(@)dtu.dk.