Combine rows based on unique column

[excel_champ]

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.

[JBeaucaire]

'COLUMNS TO ROWS
Here's a macro for merging columns of data to one row matching for column A. There's a sample workbook too you could drop your data into and test it out.

Columns to Rows - Part 3

I tested PART 3 on your sample data and it worked with no edits.