Refining MS ACCESS Data To Csv File Using T-SQL

Hello,

I have a table with these sample data pattern:
Col1 Col2
001 2
002 1002 2
002 1
003 4003 4003 3003 3003 5

The expected output in the csv file should be exactly like this:
001,2
002,4002,002,
003,19003,003,003,
003,
In the csv file, the number next to the topmost 002 is the sum of the Col2 where Col1
is 002 and the remaining field next to other 002 rows will be blank, the same process repeats for 003 and so on.

Would anyone please help me to make a T-SQL statement for the above requirement? I am using VB codes.


Thanks

k