Hi all,
I'm a newcomer and have to confess that I'm a little computer illiterate, so looking for help in its most basic form.
I have all of this data in large .csv files that, when opened in a worksheet, look something like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Time[/TD]
[TD]W1[/TD]
[TD]W2[/TD]
[TD]W3[/TD]
[TD]W4[/TD]
[/TR]
[TR]
[TD]0.1[/TD]
[TD]23[/TD]
[TD]55[/TD]
[TD]65[/TD]
[TD]80[/TD]
[/TR]
[TR]
[TD]0.2[/TD]
[TD]12[/TD]
[TD]45[/TD]
[TD]35[/TD]
[TD]21[/TD]
[/TR]
[TR]
[TD]0.3[/TD]
[TD]15[/TD]
[TD]65[/TD]
[TD]87[/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]0.4[/TD]
[TD]95[/TD]
[TD]73[/TD]
[TD]87[/TD]
[TD]34[/TD]
[/TR]
</tbody>[/TABLE]
I'm trying to do a stats analysis on it, but the program requires the data to be in individual .csv files separated by columns, but with each .csv also containing the 'x' values (Time). So 1.csv would be the Time and W1 columns, 2.csv would be the Time and W2 columns, 3.csv the Time and W3 columns, and so on.
Having looked around for suggestions on how this might be done, it seems that splitting the worksheet into rows is more common, but I'm struggling to find any macros to create the columnated data.
I'm hoping that the question is clear, but feel free to request further info. Any help would be greatly appreciated.
Many thanks,
James
I'm a newcomer and have to confess that I'm a little computer illiterate, so looking for help in its most basic form.
I have all of this data in large .csv files that, when opened in a worksheet, look something like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Time[/TD]
[TD]W1[/TD]
[TD]W2[/TD]
[TD]W3[/TD]
[TD]W4[/TD]
[/TR]
[TR]
[TD]0.1[/TD]
[TD]23[/TD]
[TD]55[/TD]
[TD]65[/TD]
[TD]80[/TD]
[/TR]
[TR]
[TD]0.2[/TD]
[TD]12[/TD]
[TD]45[/TD]
[TD]35[/TD]
[TD]21[/TD]
[/TR]
[TR]
[TD]0.3[/TD]
[TD]15[/TD]
[TD]65[/TD]
[TD]87[/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]0.4[/TD]
[TD]95[/TD]
[TD]73[/TD]
[TD]87[/TD]
[TD]34[/TD]
[/TR]
</tbody>[/TABLE]
I'm trying to do a stats analysis on it, but the program requires the data to be in individual .csv files separated by columns, but with each .csv also containing the 'x' values (Time). So 1.csv would be the Time and W1 columns, 2.csv would be the Time and W2 columns, 3.csv the Time and W3 columns, and so on.
Having looked around for suggestions on how this might be done, it seems that splitting the worksheet into rows is more common, but I'm struggling to find any macros to create the columnated data.
I'm hoping that the question is clear, but feel free to request further info. Any help would be greatly appreciated.
Many thanks,
James