Hi everyone. I'm a new user and I'm having a hard time transposing some data in excel.

I found this thread (http://www.excelforum.com/excel-work...matically.html) on transposing data automatically but I have a different setup and I don't understand fully the codes in that thread.

basically I have 5 different topics with 40 items.

topic1 topic2 topic3 topic4 topic5
a1 b1 c1 d1 e1
a2 b2 c2 d2 e2
a3 b3 c3 d3 e3
a4 b4 c4 d4 e4
etc

So what I want to happen is transpose everything getting 2 from each topic.

a1
a2
b1
b2
c1
c2
d1
d2
e1
e2
a3
etc...

or at the very least (if its too hard) into something like this:

a1
b1
c1
d1
e1
a2
b2
c2
d2
e2

All help will be greatly appreciated. :-)

thanks a lot!