Dear group members,

I have stumbled on a problem and need your help. Here is a link to the file
because it is a bit difficult to explain in words:
http://ifile.it/82dlhcn

Here is what I want to achieve:
I have my data in sheet "Main" and pivottable based on that data in sheet
"Summary". In pivottable report, I want Status column to repeat in every
company at the end of Value column. Is it possible?

TIA

Perhaps nobody is interested to pick up the file. I forgot to mention in
earlier post that it is actually .xlsx file so there is no harm to dl.

Anyway, here is the question in plain words. Is it possible to repeat the
field (which is text) in every column labels.

Regards.


"shabutt" wrote:

Dear group members,

I have stumbled on a problem and need your help. Here is a link to the file
because it is a bit difficult to explain in words:
http://ifile.it/82dlhcn

Here is what I want to achieve:
I have my data in sheet "Main" and pivottable based on that data in sheet
"Summary". In pivottable report, I want Status column to repeat in every
company at the end of Value column. Is it possible?

TIA