Snasui Excel Forum

Need Help!
I want to pivotize this dataset using Permission Type column and want an X as value for each column (which will populate after pivot option)
Issue is, in some cells the Permission Type column is having value as "PWP Interested Party" and "PWP Signatory" I don't want to pivot rows which has any one of these two values.
Instead of this I want "X" in Other, Tax Document and one more column is a row is having PWP Interested Party or PWP Signatory as value in its Permission Type Column.
a template is attached for your reference. I hope you guy will help me.

Thanks

I need to pivot data sheet on the basis of O column in data sheet Which is Permission Type.I've already tried to do pivot and output result is shown on detail sheet

I guess you need custom format to show 'X' in value area (Column 'P' on sheet data) of each permission Type. See picture below and PivotTable report in Sheet1 in attached file.

Thank you