Hi Marc,
try this:

1. Copy your data (values only, not headings) Paste it to a free part
of your worksheet.

2. In the empty column immediately to the left of your pasted data fill
down this series 1,2,3,4,5,.... down to the last row of data. Quickest
way is type 1 in the cell that is in the same row as your first pasted
data value, then 2 in the next cell down, then select both of those
cells, then use the fill handle (little cross that appear when the
cursor is over the bottom-right corner of the selection) to drag down
to the bottom of that column. You could also double click when the
little cross appears and it will fill down to the bottom of the sheet.

3. Select this new column and all of your pasted data. Click in the
Name box on the left side of the formula bar, type DATA then press
enter. DATA is a named range that will be used by the following VLOOKUP
formula

4.Type the following formula into an empty cell that is in row 3 and
has only blank cells below it:

=VLOOKUP(INT(ROW()/3),DATA,MOD(ROW(),3) + 2, FALSE)

Then fill that formula down till it stops showing your data in its
transposed state.

5.Copy and Paste SpecialValues the transposed data to where you
finally want it.

Let me know how it goes.

Ken Johnson