I have a very large table with A1 = text in A2= text in A3.......= text in
A20 etc
e.g. A1 animals = cats (A2); dogs (A3); horses (A4)

I need to transpose this (and I have gone through the existing list of
queries) so that the text from all columns apart from column 1 is listed in
column 2 with as many new rows inserted as needed. This will make checking
much easier
e.g.

animals cats dogs horses etc
trees oak birch sycamore etc

becomes

animals cats
dogs
horses

trees oak
birch
sycamore

Is there an easy way to do this (I am not familiar with Basic)? Any
suggestions most welcome, thanks.