Toggle Help Topics Menu >

Remove Repeating Data

The Remove Repeated Data can be used on a range that has the same content repeated in rows or columns. Given a range like this:

repeating-data

Removing the repeating data will result in this:

non-repeating-data

Form Fields

  • Range: Select the range to remove the repeating data from. (This field is preset with the selected range when the form is opened.)
  • Direction: Set the direction based on whether the repeated data is in columns or rows.
  • Save workbook: See Close and Re-Open Workbook for details.

Related