combine in pivot

[vjharry]

Hi,

I have these three columns data in which i want to use pivot where with a condition like in the file of Row label should show COULMNA&COLUMNB like pivot should show "JOHNTACK" in pivot

First Name Last Name Location
John tack US
Roul mont UK
Mat hardy Asia

[MarvinP]

Hi VJ.

See the attached. Is this what you want with a helper column that puts two strings together?

[vjharry]

Hi, I need to show it without using "columnD" (Helper)!

[MarvinP]

OK VJ,

This is as close as I can get without a helper column. I hope it works for you. You need to go into the design and outline and repeat to get. Otherwise I don't think it can be done exactly like you want.

[vjharry]

sir... sorry this is not that output which i was expecting

[MarvinP]

Hi VJ,

I'm going to study http://www.pivot-table.com/2009/10/2...e-values-area/ to see if it solves your question.

See also http://www.ashishmathur.com/display-...a-pivot-table/

You and I will study both of the above to see if there is an answer.

It would help if you attached a sample of what you have and show EXACTLY what you want to arrive at, for an answer

Here is a better explanation of the problem with a better answer??.
http://social.technet.microsoft.com/...9-24de1d60c526

AND here is an example and how it is done.
http://chandoo.org/wp/2012/05/07/dis...s-without-vba/

I'm still not sure any of the above does exactly what you are looking for....

[vjharry]

I tried my best but not able to solve.. could u pl check again a.. now i have attached screen shot also which i need output

[MarvinP]

Hi VJ,

My best answer is you are going to need a helper column like I suggested in my first post. Sorry, I think you are asking Pivots to do more than they can.

All those Text In Pivot Tables examples are putting the text in the Values Area. You are trying to combine text in the Rows Area. Helper column

[vjharry]

pl See attached where i have combined it in Values but not able to to for Text formats