Custom Reports with multi currency Balances , amount to be split into individual row

Summary:

There's one custom report we are trying to generate in which there's one column Currency Balance. Ideally we want only one currency and amount to be shown in one row and if there are multiple then for next currency there should be a new row.

Profile has set up as multiple currency with Entered/Functional/Reporitng balances and for each there would multiple entered balances, one functional balance and one reporting balance.

While we execute custom reports, we observe that all currency balances are grouped in one cell, separated by a <BR> identifier. Ideally we want only one currency and amount to be shown in one row and if there are multiple then for next currency there should be a new row. Is there any way to generate a custom report that gives us a separate row for each currency balance?