combine two records into one

[alexogir]

I have two records:

------------------------------------
field1 | field2 | field 3 | field4 |
---------------------------------
A | 1.1 | 1 | |
---------------------------------
A | 1.1 | | 2 |
---------------------------------

Is there any way to combine to records into one like that

------------------------------
field1 | field2 | field 3 | field4 |
------------------------------
A | 1.1 | 1 | 2 |
------------------------------

Thanks in advance for any ideas

 

[alexogir]

I've got it, used MAX for fileds 3 and 4