Home |
Search |
Today's Posts |
#1
|
|||
|
|||
arrays and pivot table
I have a worksheet in the following format:
January February March April Salesman A Product A 22 11 3 6 Salesman B Product A 2 33 5 3 Salesman B Product B 6 4 6 7 I'd like to use a pivotable on this. To do that I am trying to convert the above into something like Salesman A Product A January 2 Salesman B Product A January 3 Salesman B Product B February 4 etc. Now first of all, am I going the wrong way about this or is there a way of getting the pivottable from the fist array. If not, how do I convert the first array into the second. Cheers, Carsten |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating % in a pivot table | Excel Worksheet Functions |