Need to unmerge cell to single cell after pivot

rathsrikant07 

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