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