Column stacking

[rajat_del]

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 ?

[binuacs]

@rajat_del  it should work with cross tab

[csmith11]

Works for me as well: See solution attached. You should be able to copy the tool right into your workflow from mine.