Abstract: Systems and methods are provided to for automatically generating an N dimensional model table in a spreadsheet program. A model table function or add-in is executed as part of a spreadsheet program. More than two selections of one or more rows or columns from two or more tables of the spreadsheet program are received from a pointing and selection device. Each selection represents a different data dimension of more than two different data dimensions of the two or more tables. A model table is generated in the spreadsheet program from the more than two different data dimensions selected from the two or more tables by automatically repeating the elements of at least one data dimension of the more than two different data dimensions.