Your example is not clear.
Could you specify Var1, Var2 & var 3's values

HTH
--
AP

"Dave" a écrit dans le message de news:
...
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?