Splits an input dataset by unique attributes.

This method is very useful when a splitting dataset by defining as split field (Year, PO, Commodity, etc) into multiple or separate datasets

Cosolidate data from multiple sheets into single worksheet

Joins the contents of a table to another table based on a common attribute field. The input table is updated to contain the fields from the join table. You can select which fields from the join table will be added to the input table.