Flattening a rectangular data table means converting the table into a list of its component triplets (row, column, value). The command-line flattening shown here can also be used to flatten within a spreadsheet.

Source: LXer – How to flatten (“unpivot”) a data table