Translations:Basic Excel/185/en
However, we strongly advise against using 'Gabung & Ketengahkan', because it seriously limits the ability to use the data in any other way. (An alternative method of producing the same appearance as a merge, but without merging any cells, will be demonstrated in the advanced workshop). Pivot tables cannot be based on data that contains merged cells, so any merged data needs to be unmerged, and replaced with the appropriate contents, as demonstrated below: