Find the attached file. If you want filter I-S then filter records using WHERE statement.
Hope it help you.
CrossTable.qvw 120.8 K
Thanks for your reply dude.
But my problem is a bit different. Actually there are ~50 columns and 581514 rows, and i need to transpose only 24 columns somewhere in between. My worry is if m gonna do this my relation with the rest of the data in the table will be lost, which i am presenting in Chart.
In the example you can specify the starting column index( I - 9 in excel) in the following script in the cross table
Refer the previous attached example qv file script :
CrossTable(Date, Sales, 9) --> here the value 9(starting point) mentioned the data can be merge from I column from the excel.
but we cant set the end point so,
we want to remove the column using where condition or manually.