J
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.
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.