How to convert a pivot table into a simple table ??as cut & paste is not possible. I have a pivot table in which months are not serial wise and i want to arrange them.
vishakha sharma (Article) (59 Points)
06 October 2012How to convert a pivot table into a simple table ??as cut & paste is not possible. I have a pivot table in which months are not serial wise and i want to arrange them.
Ganeshbabu K
(Audit and Tax Advisory)
(48559 Points)
Replied 06 October 2012
select pivot table range,and apply ctrl+c
then go where u want to paste,do pastespecial,short cut key,
pastespecial,rightclisk,s,s,v+enter
Ganeshbabu K
(Audit and Tax Advisory)
(48559 Points)
Replied 06 October 2012
1)ctrl+c
2)right click,s,s,v,and enter
it is what doing pastespecials
vishakha sharma
(Article)
(59 Points)
Replied 06 October 2012
but in pivot table paste special also does not work
Ganeshbabu K
(Audit and Tax Advisory)
(48559 Points)
Replied 06 October 2012
why it wont works for u,while it works for me,
find file here,
CA S.Parameswaran
(CA)
(25 Points)
Replied 06 October 2012
You might have selected the entire pivot table... Follow the below steps and let us know if it works...
1. Exclude the Report filter or the column lable - depending upon the type of pivot table you have created.
2. Then select the balance table and copy...
3. Paste it in the requisite location.
vishakha sharma
(Article)
(59 Points)
Replied 06 October 2012
Hey guys it is not possible to drag the rows in a pivot table. i want to make the changes in the current pivot table instead of paste.
Ganeshbabu K
(Audit and Tax Advisory)
(48559 Points)
Replied 06 October 2012
CAclubindia
