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
Thanks,
Ankit