Split single line entry into mutliple table entries using BODS.

Hi All,

I have a question on how to resolve splitting a single entry input into mutliple line entries using BODS.

Example we have Column 1, Column 2, Column 3 and the output will have 3 lines with Line 1 value from Column 1, Line 2 value from Column 2 and Line 3 value from Column 3?

Is there a loop that can be utilized inside a Data Flow?

What I had thought of is current using a CASE and a MERGE to resolve this.

Are there a better solution to this?

Thanks,

Tim