There are 64 columns - I would like to combine multiple rows into a single row based on Employee's name in column A. There will be dates in certain columns (if possible, only the most current date will stay, older dates will be deleted)
Also, there will be blank cell in various rows and duplicate values in different rows of the same column, if possible, I would like to combine cell values/text into one row from the same column that has the same employees.

This list will continue to grow and does not have a 'stopping' point other than me removing data myself.

What I have:
Employee's Name Date Value A Value B Value C Value D Value E Date Value G
Employee 1 9/1/17 X X X 4/12/16 X
Employee 2 5/3/17
Employee 1 9/17/17 X X 3/1/16 X
Employee 1 12/1/17 X X X
Employee 3 2/3/16 X X 8/2/17
Employee 2 2/14/17 X X X X X 5/5/17 X
Employee 2 2/14/17
Employee 4 6/7/17 X X 6/7/17 X
Employee 3 1/1/16 X X 6/30/17
Employee 4 X
Employee 5 7/24/17
Employee 6 11/1/17

Desire results:
Employee's Name Date Value A Value B Value C Value D Value E Date Value G
Employee 1 12/1/17 X X X X X 4/12/16 X
Employee 2 5/3/17 X X X X X 8/2/17 X
Employee 3 2/3/16 X X 6/30/17 X
Employee 4 6/7/17 X X X 6/7/17 X
Employee 5 7/24/17
Employee 6 11/1/17