Tranpose columns to Rows

Hi

I am after a way to get data to move from a column to a row. I can use the transpose command but I want multiple rows cut form the 1 column eg

column A
dog1
dog2
dog3

cat1
cat2
cat3

I would like :-

dog1 dog2 dog3
cat1 cat2 cat3

Thanks for your help

Dear,
Use VBA programming to move the corredponding rows to colums seperating them whenever a space is encountered...

Please Login or Register  to view this content.

Hi Roy,
I think both the codes that you have provided work fine but do not place the data in the next row, whenever a break occurs (i.e. a blank row is encountered)...

original data:-

a
b
c

a
b
c

a
b
c


Output of your code results is some thing like:-

abc abc abc


whereas it should be:-

abc
abc
abc


no doubt your code is an optimal one but if you could manipulate the data in the required fashion it may be halpful to Beardie