Hi Tom - Here are some answers to your questions:

"Tom Ogilvy" wrote:

if it is 300 x 300, you would need to write out 90,000 rows, but there are
only 65,536
Ya, I will then bring this new file into Access. I would bring the original
file into Access but it has the 256 variable limitation as well.

is the first row and first column actually variable names.
Yes

A CSV file usually means comma separated, but you show fixed width. What
does your file actually look like?
Sorry, I should have been more specific. I just posted an answer to Ardus'
question that shows an example of what my file actually looks like.

do you really need the result in excel or just write it back out to another
CSV file?
Output to a .csv file would be great.



In your sample output,
Var1, var2, 2

is the Var1 from the left side of the input (row) or from the top row
(column)?


You show
row var, column var, value

(based on the value 2), but just to be sure.
Thanks for clarifying, yes this is correct.


--
Regards,
Tom Ogilvy


"Dave" wrote:

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?