1
2
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
I'm really curious about this, since I can't think of any elegant feature that Excel has to do this. The transposition isn't the problem. It's the way you're grouping things that is unconventional. What are you going to do with the data after it's grouped like that? Maybe we can help get you to that point without the precise step you're attempting. – Dane – 2013-07-08T16:12:39.897
This is not possible. – Fergus – 2013-07-08T16:27:57.853
1
See this: http://superuser.com/q/366616/76571 My answer can be adapted to fill columns rather than rows.
– Excellll – 2013-07-08T18:29:46.540