Method and system for improved ordering of output from spreadsheet analytical functions

A method of evaluating data in a spreadsheet using a table generator function that applies a user specified formula to user specified data fields, including:

• accessing from the spreadsheet a formula for the table generator function formula entered in a first spreadsheet cell, wherein the table generator function applies the user specified table generator function formula to generate a table of labeled results populated in a plurality of cells;
• wherein the table generator function is a prebuilt spreadsheet function that has a name and opening and closing characters between which different types of arguments are separated by a single type of delimiter;
• receiving an argument of a loops argument type followed by at least one argument of a formula argument type and at least one additional argument of the loops or formula argument type specified by the user, in a user determined number and order, the arguments separated by a single type of delimiter;
• wherein each argument of the loops argument type specifies a data field used to create a loop equivalent;
• wherein at least one loop equivalent group input from two or more cells in the cell range or from two or more records in non-spreadsheet cell data that have matching values in the data field used to create the loop equivalent group;
• wherein the formula argument type applies at least one range function to at least one user specified data field input for all preceding argument(s) of the loops argument type;
• outputting from the table generator function loop equivalent formula results from the formula argument type(s) and outputting adjacent thereto related labels from the loops argument type(s).