Need to unmerge cell to single cell after pivot

Copper Contributor

Hi Team,

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

Output.png

Regards,
Sriku

1 Reply

@rathsrikant07 

Assuming you have PivotTable like

image.png

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

image.png