• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot Tables Customizatoin

rawatankit1

New Member
Hi, I want to create a 2 column Pivot table, in which the criteria i.e. the first column of pivot should be the combination of 2 columns of the source excel & the second column of the pivot should be the corresponding value. For example if one column of the source excel file is A,B,A,C,B...., second column is I,II,III,I,IV,II,.... & there are values in third column. I am looking for a pivot of 2 columns where the first column should be AI, AII, AIII, AIV & the corresponding values of these in the second column of the Pivot. Is it possible?


Thanks,

Ankit
 
Hi Ankit!


Welcome to forum


Please upload sample book so we can give u solution after better understanding


below is the method of posting sample workbook in forum


http://chandoo.org/forums/topic/posting-a-sample-workbook
 
Back
Top