0

I have a Excel sheet like below..

Color   Size    Qty
Red     L       182
Red     M       223
Red     S       155
Red     XS      30
Blue    L       700
Blue    M       845
Blue    S       665
Blue    XS      357
Green   L       173
Green   M       200
Green   S        67
Green   XS       34

But I need to convert that sheet as per below...

        L   M   S   XS
Red     182 223 155 30
Blue    700 845 665 357
Green   173 200 67  34
  • 3
    Did you try using Pivot tables? – Dave Aug 28 '13 at 11:47
0

Either a pivot table or copy - paste special - transpose

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.