If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to create a crosstab in Excel
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! |
#2
|
|||
|
|||
How to create a crosstab in Excel
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! |
Thread Tools | |
Display Modes | |
|
|