>>how i can create cross tab like this
>>
>>i two row
>>1. Code
>>2. Name
>>
>>two col
>>1.Month_qty
>>2.month_value
>>
>>Code | Name | April Qty| April Value |May Qty | May Total
>>101 | Textile| 5200 | 4500120 | 4501 | 8520122
>>
>>
>>warm regards,
>>mk
>
>Does anyone here still have the programs from the old CIS board?
>I remember a couple of people doing nice code to get crosstabs without needing a spreadsheet to do the heavy lifting.

You can check FastXTab from Downloads section here, but I doubt it supports two columns, such as value & amount.