data arranging

Hi,

I have data from an old instrument coming off in an awkward format and i need to graph and process 100's of files.

The file format is some redundant text of sampling time, description, and the raw data in the following format:

COLUMN NO.
1 2 3 4
ROW1 50 25 60 20
ROW2 25 12 45 23
ROW3 16 16 50 12

We need to plot this raw data (y axis) against a fixed time domain (x axis), for each replicate (1-15 replicates). Please find attached a xls file of what I am trying to do.

Time Intensity
0 50
0.1 25
0.2 60
0.3 20
0.4 25
0.5 12
0.6 45
0.7 23
ETC. ETC.

I really need some help on this as we have a grant related deadline for this data and my macro skills are not the best

Help please :-)