I have a spreadsheet with 27 columns, consisting of
names, and 26 other items particular to that name. In
another sheet (within the same file) I would like the
same information to appear, but transposed; I would end
up with a sheet with 27 rows and an undetermined number
of columns (one for each name). his is to facilitate
printing indiidual records.

I need to come up with a method by which, after I add
records to the first sheet (27 columns), I can copy it to
the 2nd (27 rows) without copying cell references one at
a time. Any ideas?