I have a simple spreadsheet that looks like this:
Origin State Dest State Company
AL AL A
AL AR A
AL AZ B
AZ AL A
AZ AR C
....and so on. Basically, the first 2 columns have all states/provinces and
column 3 has the company we use. I need to create one matrix with all
states/provinces in Row 1 and in Column 1, and all the cells in between are
populated with the company.
Question is How can I do this using MS Excel using Pivot Table. I can do this
using Business Objects or Crosstab Query in MS Access but how do I do it in Excel using Pivot Table? This can be done by
using INDIRECT and MATCH functions but this involves a couple of steps. Is there any shorter method?
attached an excel sheet that gives what I have, What I can do using Access or Business Objects and what I get using Pivot
Table in Excel. The normal Pivot Table in Excel gives numbers instead of the company name even if I use Max or Min function
(which works fine in MS Access query). So what am I missing here?
Thanks in anticipation,