Sorry, the previous link didn't work. I hope this one do!

http://www.pixagogo.com/4241115951

If you follow this link (click on origineel for better quality):

http://www.pixagogo.com/Photos/Albums/Photo.aspx?id=S4N01J4Hlna5uUyULiHkX44Hg6nxqi0UIp5t6K3IzSuQrOS8FvQ911mWyYtNAKnDSNbFzPNExdPwGrzh7nVf1e3Q__

Can you see it now?

You mean like this:

Yes. My results are from a policysystem and I'm trying to merge the rows with

the same policynumbers (first column).

I wil show you a print screen put in excel:

I hope thiw...

Because they made one field 'vartkst' for different columns. I find out that

e.g. veldc 2, 6, 10, 14, 18, 22 is for the column that i'll call PolisNr. This is also

the case...

The query is as follows:

select DISTINCT m.ponr    PolisNr

  ,   CASE WHEN veldc    in (2, 6, 10, 14, 18, 22)

      THEN vartkst       

 END     PolisNrOud

  , CASE WHEN veldc    in (3, 7, 11, 15, 19, 23)

      THEN vartkst       

 END     Maatschappij

  , CASE...

Thanks for your answer, but your right. It doesn't solve my

problem, because there are also ocurrences where there are

three or more records that I have to merge... (min and max

are...