Im trying to write a vba macro for an excel spreadsheet that will
format cells from this;
A B C D
1 rat z1 z2 z3
2 cat x1 x2 x3
3 bat c1 c2 c3

to something like this

A B
1 rat z1
2 rat z2
3 rat z3
4 cat x1
5 cat x2
6 cat x3
7 bat c1
8 bat c2
9 bat c3

has anyone encounted a macro which does this or something
similar, or if not, has any idea about how to break down the
problem into logcial steps.


---
Message posted from http://www.ExcelForum.com/