Thread: Pivot Table

Hi All,

I am making the table of matrix using pivot table. Pivot table works perfectly if the data is defined in each row. This has been explain in part2 & pivot part 2

But if you merge all the common row it will never show the data correctly. Please help me in knowing the root cause or some basic mistake which I am doing (Find attached the Excel)

Thanks & Regards
HK

No attachment.

I see it now.

When you say common row, what do you mean? Could you be more specific?