I don't think I'm phrasing the question correctly so I'd be pleased if someone could edit it to something sensible!
I'm using Excel 2010 and I have a set of data like this:
Art 12
Bob 15
Bob 18
Kev 16
Kev 13
Kev 14
Kev 20
Deb 12
Deb 21
I want to turn it into this:
Art Bob Kev Deb
12 15 16 12
18 13 21
14
20
The paste-special transpose option doesn't do quite what I want but it is close. It gives me this:
Art Bob Bob Kev Kev Kev Kev Deb Deb
12 15 18 16 13 14 20 12 21
How can I transform the data in the way I need?
Thank you