Hi,
Can anybody help me with this little beauty? I am a first time loop guy
so not sure what to do here... I have a table of data 8 columns wide and
normally 40 rows high. I want to copy rows A1 to H1 and
transpose them into a single column (e.g. column N)then take the values
in A2 to H2 and transpose them into the same column underneath the
previously transposed column (N). What I am trying to achieve is to
take this table of data and turn it into a single serial string. Also
when the macro loop first starts it needs to check the column it is
transposing to (e.g. N) does not already have data in it, if it does
then it needs to transpose to an adjacent column.

Narly...yes?? Any help very much appreciated


Cheers

Simon


--
simonsmith
------------------------------------------------------------------------
simonsmith's Profile: http://www.excelforum.com/member.php...o&userid=34235
View this thread: http://www.excelforum.com/showthread...hreadid=539963