Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello - I have a csv file in the form of a matrix with 256 variables (e.g.
300 x 300) that I want to summarize to a column report. For example: Var1 Var2 Var3 Var1 1 2 3 Var2 4 5 6 Var3 7 8 9 And I would like the output to be: Var1, Var1 1 Var1, Var2 2 Var1, Var3 3 Var2, Var1 4 Var2, Var2 5 Var2, Var3 6 Var3, Var1 7 Var3, Var2 8 Var3, Var3 9 Anyone know of an easy way to do this in VBA? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Column multiplied by a matrix | Excel Discussion (Misc queries) | |||
Making a Matrix into a column....... | Excel Discussion (Misc queries) | |||
How would I create a report from data in a matrix | Excel Discussion (Misc queries) | |||
how do i create a report from a matrix | Excel Discussion (Misc queries) | |||
Matrix to single column | Excel Worksheet Functions |