Reduce Rows to One

This action creates a new worksheet and the original source worksheet remains unchanged.

If a document has information spread out across multiple rows that is related to a single object, you can use this action to gather the spread out information and have it all placed into one row for the object (for all objects selected in your worksheet). After using this action to convert the format into single row records, you can to take advantage of important Excel features (Sort, AutoFilter, Advanced Filter, etc.) and Refinate features (compare, item counts, etc.). Additionally, this action can consolidate (and optionally sort) many cells of items into a single cell of the record (consolidating and sorting reference designators or netlist nodes, for instance). This version of Refinate recognizes the start/end of each record based on one of three document format styles; “Indented,” “After Empty Cell,” or “Name Change.”

For example, if a BOM uses many rows per part and has reference designators spread across multiple rows, this action can be used to reduce the parts information down to one row while consolidating all referenced designators into a single cell of the record. You can then use Refinate to place into the adjacent column an accurate count of each part’s reference designators — which is the true amount of parts needing to be purchased. This works even if the reference designators are represented using hyphenated range notation (e.g., resistors “R1-R4″ will be counted as 4 items). As another example, this action can consolidate nodes of a netlist so that Excel can be used to sort the list, or so that Refinate can be used to compare different netlist documents against one another.