How to merge multiple records into one and update the cells

[mag]

I have a huge excel spreadsheet with about 10,000 records.
It looks somewhat like this:

Last First JDE SAP Oracle WMS HR
Smith John Y Y
SMITH JOHN Y
Smith JOHN Y

Basically i want top merge all 3 records into one and update the cells also to look like
Last First JDE SAP Oracle WMS HR


Smith John Y Y Y Y

Please tell me how can I do this.

Also I tried using "=proper" statement to change names into sentence case (e.g. JOHN changed to John), but I get a #ref error.
Why?

I need a solution asap...plz.

Any input is greatly appreciated!