1. A computer system for modeling tabular data with mixed column and pivot table layout the computer system comprising: one or more computer processors; one or more computer-readable storage media; program instructions stored on the computer-readable storage media for execution by at least one of the one or more processors, the program instructions comprising: program instructions to receive tabular data containing a set of columns and rows, from a data source, wherein columns in the set of columns contain a category label and metric data; program instructions to determine, for one or more columns in the set of columns, a corresponding metric type; program instructions to identify grouped and ungrouped columns in the set of columns, wherein grouped columns comprise one or more pivot type columns, wherein a pivot type column corresponds to a column sharing a predetermined metric type with an adjacent column, and wherein ungrouped columns comprise one or more columnar columns, wherein a columnar column corresponds to a column having unique metric types compared to adjacent columns; and program instructions to generate a table comprising a first sub-table and a second sub-table, wherein the first sub-table further comprises the tabular data of the ungrouped columns and the second sub-table further comprises comprising the tabular data of the grouped columns.