What you want here is a crosstab. I use FastXTab from Downloads section here, I think it may be configured the way we need.

Otherwise it's not hard to write a program to transpose the data.

>Roy,
>
>Please review message #1257587 and this thread.
>
>>Hi
>>
>>the following table:
>>
>>

>>
>>Salesperson   Store       City         Amt1        Amt2        Amt3 
>>---------------------------------------------------------------------------------------
>>Mark             AAAA     Miami           50          120           10
>>Mark             AABB     Orlando         70           60           80
>>Sally            BBBB     Tampa          110           30           50
>>Sally            CCCC     Toledo          40           25           10
>>Sally            DDDD     Chicago         15           35           55
>>
>>

>>
>>I need to create a report ordered by salesperson and should Display like this on report:
>>
>>

>>--------
>>Mark
>>--------
>>Column1  Column2  Column3 .... Column10
>>-------------------------------------------------------------------------------
>>AAAA     AABB     
>>Miami     Orlando     
>>50           70         
>>120          60          
>>10           80          
>>
>>
>>--------
>>Sally
>>--------
>>Column1  Column2  Column3 .... Column10
>>-------------------------------------------------------------------------------
>>BBBB     CCCC      DDDD
>>Tampa    Toledo    Chicago
>>110        40         15
>>30         25         35
>>50         10         55
>>
>>

>>Could be up to 10 columns at most. I remember I did this a while back, but I can't find the code and want to know the best way to accomplish this.
>>
>>Thanks for the help!.