4 Small multiples

You might have heard the term ‘small multiples’ in the context of graphs, but it also occurs in spreadsheets, when an array of small tables could be combined into a single table.

To import an array of small tables, start by writing the code to import one, and then apply that to each in turn.

  1. Write the code to import one table.
  2. Wrap that code in a function.
  3. Partition the whole spreadsheet so that each table is in one partition.
  4. Map the function over the partitions.