Hi everyone! Need help ASAP!

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. (I hope this makes sense).

How can I do this? Please help, I have to get this published TODAY!

Creating a Pivot Table in Excel

1.

1. Select all the data in your spreadsheet, including the headers.
2. Go to the Insert tab in the ribbon at the top of the screen.
3. Click on PivotTable in the Tables section.
4. In the Create PivotTable dialog box, make sure the range of your data is correct and choose where you want to place the pivot table (either in a new worksheet or in an existing one).
5. Click OK.
6. You should now see a blank pivot table and a PivotTable Fields pane on the right side of the screen.
7. Drag the Origin State field to the Rows area in the PivotTable Fields pane.
8. Drag the Dest State field to the Columns area in the PivotTable Fields pane.
9. Drag the Company field to the Values area in the PivotTable Fields pane.
10. You should now see a matrix with all the states/provinces in the rows and columns, and the cells populated with the company names.

You can customize the pivot table further by adding filters, changing the calculation type, and formatting the table to your liking.

Crosstabs are called Pivot Tables in Excel.

Make sure that your active cell is in the data,

In xl 2003 choose Data, Pivot Table

In xl 2007 choose Insert, Pivot Table

Your list must have Headings preferably emboldened. Excel uses the Heading
as fields just grab the fields until you find a suitable layout. Say Dest
stae as row headings, Origin State as column Headings and companies as data.


"Jeanne" wrote:

Hi everyone! Need help ASAP!

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. (I hope this makes sense).

How can I do this? Please help, I have to get this published TODAY!