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,
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,
Last edited: