| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing a crosstab | Excel Worksheet Functions | |||
| Transpose Crosstab Data in Excel 2000 to flat file for use in MS A | Excel Discussion (Misc queries) | |||
| Need crosstab function in excel | Excel Worksheet Functions | |||
| Vlookup "crosstab" | Excel Worksheet Functions | |||
| How do I create a crosstab process to determine patterns in surve. | Excel Worksheet Functions | |||
Threaded Mode
