Multivalues Comma Delimited Fields to Split

[khan007]

I M on CR 8.5, Win 2k.
I am facing problems with multivalue fields, delimited with commas.

I have three fields in my report haveing multiple values seperated by commas.
like:
ID Unit Amount Code
001 1,2,3 100,200,300 XXX, SSS, DDD

But my required output should be

ID Unit Amount Code
001 1 100 XXX
2 200 SSS
3 300 DDD

Please help me how can i split these values in exact number of rows as values count.

Thanks in advance.

 

[synapsevampire]

You may run into size constraints (254 char max output), but create a formula for each field:

join(split({table.Unit},",&quot,chr(13))

-k