I have a cross tab which does comparison between different vendors.The list of vendors may exceed to 100 which is visble in the cross atb but when i download it in excel ,whole data is not refelcted due to column (256)restriction in excel.
I need to spilt the data so that each apge ahs fixed coulmns with the set of five vendors for comaprison.
I want to split the data vertically in set of four or five.

How to do this in Cross Tab.I am using version 11.