Data from Column to Row

[sxmajmda]

I hope someone can help me with this, I have fruit name in Col 1, fruit color in Col 2, and quantity in col3


Column 1 Column 2 Column 3
Fruit Color Quantity
Apple Red 1
Apple Green 2




I want to arrange it in this format, I want to keep the fruit name in col1, but I want to get the color data in rows


(As shown below)


Column 1 Column 2 Column 3
Red Green
Apple 1 2


How do I go about this?


Thanks in advance,

 

[Robert Mika]

I hope someone can help me with this

Column 1 Column 2 Column 3
Fruit Color Quantity
Apple Red 1
Apple Green 2

I want to arrange it in this format

Column 1 Column 2 Column 3
Red Green
Apple 1 2


How do I go about this?

Thanks in advance,

The Quickest:
Pivot Table
Column Labels: Color
Row labels:Fruit
Values:Quantity