| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a matrix from data in three column
I have data in three columns. I would like to take this data and create a matrix from this data. So, data in columnA become column labels in matrix, data in ColumnB become row lables in matrix and data in columnC populates the matrix (crossection of columnA and ColumnB values). I would prefer if this is done via macro/VBA but a formula will be fine too. Thanks for help in advance. Jay -- sa02000 ------------------------------------------------------------------------ sa02000's Profile: http://www.excelforum.com/member.php...o&userid=27747 View this thread: http://www.excelforum.com/showthread...hreadid=555700 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| Stock data manipulation | Excel Worksheet Functions | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| how to put data in the column A to the next row of the column B | Excel Discussion (Misc queries) | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
Threaded Mode
