Crosstab issue

[kaarthik]

hi everyone,

I would like to get an EXCEL output in the following format. Please help

I would like to get the crossrab format showing horizontal data flow in the excel output but neither of my data is numeric. So i am unable to use crosstab, so i used repeater table but I am unable to group on the top column of the repeater table i.e the top column data is being repeated even inspite of grouping.I hava also used cast function for changing the datatype for using the data item in the cross tab, but with no luck.


required data flow in excel
country1______________________________ Country2
state1________________________________ State2
city1.1_______________city1.2_________city2.1


Please advise. Any help is greatly appreciated.!!