Combine rows based on unique column

Hi,

I need some help. I have data set as below:
A|1|||Z|
A||2||Z|
A|||3|Z|
B|4|||Y|
B||5|6|Y|
B||||

And I want to get this (based on unique values in column A)
A|1|2|3|Z|
B|4|5|6|Y|

For few columns (like last one in the above example) we always to retain the value in first row.

Can you please help me with it? Thanks.