Hi All,
I have a problem which i am stuck with.
I have basically three columns.
Fruit_type Cost Country
Orange 100 America
Orange 200 UK
Orange 300 Australia
Pear 50 America
Pear 10 UK
Pear 30 Australia
I want it in a format so
Fruit type America UK Australia
Orange 100 200 300
Pear 50 10 30
I tried cross-tab but it didn't work, is there a simple method to do this ?