Want to have 1 editable column in pivot table!!

[gameover]

Hi All,

I have made a pivot table and its working fine. I want to add 1 column to it (comments section) and it should be editable, (user should be able to write some comments for each row separately). Is it possible?
Please help me!!!

Thanks in advance!!!!

PS: The column can be in middle or in the end of Pivot table!!

 

[Oaktree]

No, you can't add a column to the middle of a pivot table.

As a sort of workaround, if your pivot table is in columns A:C, you could, however, set E1=A1 copied down, F1=B1 copied down, leave column G blank, and set H1=C1 copied down

Then, E:H would show the data from the pivot table and give you the flexibility to add comments to column G

 

[gameover]

Thanks a lot man!!! Its awesome!!!