Hi,

I have a set of data (13 cells) stored adjacently in a known column on a
sheet. What I want to do is transpose this to a row on a different sheet.
From simliar entries on this newsgroup I think I'm going to have to set up
some arrays to manage this, but not being a programmer by profession (I'm
just learning this stuff as I go along!) I'm getting a bit confused.

What I need to do is transpose

A B C
1 ADatum1 BDatum1 CDatum1
2 ADatum2 BDatum2 CDatum2
3 ADatum3 BDatum3 CDatum3

into:
A B C
1 ADatum1 ADatum2 ADatum3
2 BDatum1 BDatum2 BDatum3
3 CDatum1 CDatum2 CDatum3

There are 13 separate data entries per source column, but an unknown number
of columns with data in them. Columns with data are always adjacent to each
other, so I can use the presence of a blank cell to indicate when I have
reached the end of either a data set in a column or the last column of the
whole set.

I'd be much appreciative if anyone can show me the syntax for getting this
to work.

This is in Office '07 under Vista if that makes a difference.

TIA

Dave