For IBM Planning Analytics for Excel
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