US Patent 12073065 Data preparation user interface with coordinated pivots

A computer user interface displays a two-dimensional grid of data values. A user selects a first set of two or more columns of data values from the grid, and the computer performs a first pivot on the first set of two or more columns to form a modified grid having a plurality of new rows and a first set of two or more new columns. The user selects a second set of two or more columns of data values from the grid. The second set is distinct from the first set. The computer performs a second pivot on the second set of two or more columns to form a second new column added to the modified grid. Each data value from the second set of two or more columns is added to the second new column in a respective row of the new rows. The computer redisplays the modified grid.