Forum Discussion

Copper Contributor

Jul 11, 2024

Need to unmerge cell to single cell after pivot

Hi Team, After pivot, I want to unmerge blank cell and multiple cells to single cell data as attached Regards, Sriku

Diamond Contributor

Jul 11, 2024

Assuming you have PivotTable like

and assuming you Excel supports data model,

- creating PivotTable add data to data model

- in PowerPivot create measure as

States:=IF( HASONEVALUE(Table1[Region]),
             CONCATENATEX(Table1, Table1[State], UNICHAR(10) ),
             "" )

- insert PivotTable from data model