Can someone help me ?

I have a CSV file which can be opened in Excel. The CSV file i
comma-seperated !

Column 1 contains the cd numbers and column 2 contains the tracknumber
and names

So I do have a table with the following contents:
1,01;track1
1,02;track2
1,03;track3
2,02;track1
2,02;track2
And so on....

I want to have a formula, or result with the following contents:
1,01;track1|02;track2|03;track3
2,02;track1|02;track2

Is that possible to create ? How

--
pollewop
-----------------------------------------------------------------------
pollewops's Profile: http://www.excelforum.com/member.php...fo&userid=3399
View this thread: http://www.excelforum.com/showthread.php?threadid=53762