one option is to use msquery to access the data and write a union query
that returns just the columns acc_no, srce_sys,dq_error. you need to
rename the dq_error column so their names are unique .. add a number to
the end of each name.. dq_error1, dq_error2 etc.
the query looks like thefollowing if the data is in a csv file called
'data'.
SELECT data.Acc_no, data.Srce_sys, data.DQ_error1
FROM data.csv data
union all
SELECT data.Acc_no, data.Srce_sys, data.DQ_error2
FROM data.csv data
union all
SELECT data.Acc_no, data.Srce_sys, data.DQ_error3
FROM data.csv data
<etc up to column 19
I hope someone has an easier suggestion for you.
regards..
--
steven1001
------------------------------------------------------------------------
steven1001's Profile:
http://www.excelforum.com/member.php...o&userid=30757
View this thread:
http://www.excelforum.com/showthread...hreadid=566951