Forum Discussion
rathsrikant07
Jul 11, 2024Copper Contributor
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
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