i have one scenario
i want to convert horizontal rows into vertical rows.
For eg
Input file contains:
1001,34.7,43.7,34.99|1002,34,243,34|1003,34,43,34|1004,34,43,34|1005,34,43,34
Output file contains
1001,34.7,43.7,34.99
1002,34,243,34
1003,34,43,34
1004,34,43,34
1005,34,43,34
Here 1001 is a item with diff prices 34.7,43.7 and 34.99
so i want each item in diff rows as above
Please solve for me asap
Thanks
Prakash