Consolidation of Data

[Jason]

Is there a quick and easy way to compare pieces of
information in a row to a row below it. If the
information is identical, excel will consolidate the data
in the two rows into one row, and compare it to the next
row until it finishes the entire worksheet.

Example

Name City State Phone
Jason Anywhere XXX-XXX-XXXX
Jason Anywhere CA
Jason XXX-XXX-XXXX

when the function is run, the three rows would turn into
one row with this information in it.

Jason Anywhere CA XXX-XXX-XXXX

Any help is appreciated.