Oops, sorry, some corrections to the (description) lines:

> Put in A1 (normal ENTER):
> =IF(ISERROR(SMALL(Sheet1!$E:$E,ROW(A1))),"",
> INDEX(Sheet1!A:A,MATCH(SMALL(Sheet1!$E:$E,ROW(A1)),Sheet1!$E:$E,0)))

Should read as:

Put in A1 (normal ENTER):
=IF(ISERROR(SMALL($H:$H,ROW(A1))),"",
INDEX(Sheet1!A:A,MATCH(SMALL($H:$H,ROW(A1)),$H:$H,0)))

(The above formula is already entered correctly in the previous sample,
but missed updating in the descriptions)

Revised sample construct (corrected descriptions) at:
http://cjoint.com/?ceqdoihxCj
Transpose Multiple Columns to Single Row_whicks_gen.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---