Rows to column report

[Pr07]

Hi All,

I have seen very helpful hints to convert columns to multiple rows in a report. I am trying to do the converse:
F1 F2 F3 F4
***************************
A 1 a a1
A 1 b b1
: : : :
: : : :
A 1 c c1
A 2 a a1
A 2 b b1

F1 F2 F3-1 F4-1 F3-2 F4-2 .......F3-n F4-n
************************************************************A 1 a a1 b b1..........c c1
A 2 a a1 b b1

The value of 'n' can vary from 1-20.

Thanks for the help in advance