View Single Post
  #3   Report Post  
sansk_23
 
Posts: n/a
Default

Thank you for your help. It did really sort out my problem.
But at the same time, i am having difficulty going a step further. Problem
is as under - If i have more than one (multiple) row fields (on the left part
of the pivot table) eg. Pls. refer to the example given in the link given by
you in your reply - in addition to A1..A13 i also have B1..B13 as the total
monthly target.
So how do i get the data in the database table as Month, Target, Product,
Value. ?

"Biff" wrote:

Hi!

This might help:

http://j-walk.com/ss/excel/usertips/tip068.htm

Biff

"sansk_23" wrote in message
...
i wish to convert the data given in a tabular form (as displayed in a pivot
table) to a worksheet list. Or, in simpler words, to reverse the Pivot
Table
action without clicking the undo botton. Like we convert the worksheet
list
to a pivot table, can we convert the pivot table back in the for of a
detailed worsheet listing?