Help: formatting/grouping data in excel

Hello,

 Please advise on how I can group my dataset.

 

My current dataset:

Name T-shirt Size
Ali  Small
Ben Large
Thomas Small
Cindy Medium
Lee Medium
Tanros Large
Ernest Small
Selena

Medium

 

What I want:

Small Medium Large
Ali  Cindy Ben
Ernest Lee Tanros
Thomas Selena  

 

I have tried pivot table and got this but it is not what I want or need as my categories are actually more than this. This is just an example.

Row Labels
Large
Ben
Tanros
Medium
Cindy
Lee
Selena
Small
Ali 
Ernest
Thomas
Grand Total

 

By: helpme

Leave a Reply

Your email address will not be published. Required fields are marked *