- Points
- 22
- Trophies
- 1
- Posts
- 6
Hi,
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?
I have 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,
Warm Regards,
Kallol- Navigation
- OzGrid
- Forum
- Members
- Options
- Current Location
This site uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.Your browser has JavaScript disabled. If you would like to use all features of this site, it is mandatory to enable JavaScript.
How To Create A Cross Tab Table In Excel For Mac 2016 Free
Excel Table Function
How To Create A Cross Tab Table In Excel For Mac 2016 Free
Excel Table Function
How To Create A Cross Tab Table In Excel For Mac 2016 Autorecover Location
Step #1 – Create Table Object. Initially, Data set is converted to a table object. It can be done by the below-mentioned steps. Click inside the data set, click the Insert tab, select Table. A create table popup appears, where it shows data range & headers, and click OK. Once the table object is created, it appears as below mentioned. Jan 19, 2020 Open the filter menu. Click the drop-down arrow to the right of the header for the column whose data you want to filter. A drop-down menu will appear. In order to do this, you must have both the 'Header Row' and the 'Filter' boxes checked in the 'Table Style Options' section of the Design tab.
