> >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 > >>
>--------
>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.