The Split in Sheets application of  Optipe Data Tools Suite  allows you to split data in an Excel table based on the value of a field or column.

Data Tools Suite Extraer Datos de Tabla

Separar en HojasUse this application to:

  • Split a table into multiple sheets, depending on the value of a field.

Features:

  • The extraction is generated in a new sheet with the data you select from the table.
  • You can define the fields to extract.
  • To select non-consecutive fields, hold down the Ctrl key and then click each of the items you want to select.
See also:
  •  
 

Examples