Most valuable professional
  • Hot Topics

Excel Condense multiples into first occurrence only

Is there a way to take the first occurrence in every value change in a column and re-write it with another value in the same row? For example: Column 1 apple apple apple pear pear orange grape grape banana apple apple orange

This question generated 23 answers. To proceed to the answers, click here.

This thread is current as of February 19, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel