Merged cells, repeat labels and label top cell… what are these Grouping Options?

Excel interface showing the Grouping Option for controlling repeated elements in an Exploration or List.

Grouping Option – Control how repeated elements on the row set appear in an Exploration or List. Because an element appears in each row for ‘Repeated labels’, this options works best if you want to do a lookup like an xlookup.

Default Setting = merged cells

,