Tom Ogilvy wrote:
[b]The macro recorder with a manual copy , pastespecial transpose is
a good
recommendation - here is another if it fits your requirements.

Range("A2:A27").Value=Application.Transpose(Range( "A1:Z1"))

If you don't need formats and the cells contain constants or you
don't want
constants not formulas.

--
Regards,
Tom Ogilvy

This works fine if you're only transposing one column of data. What
if it's a column of repeating data to convert into multiple columns?

name1
address1
phone#1
name2
address2
phone#2
name3
address3
phone#3
etc.... for the next few hundred rows to be converted to

name1 address1 phone#1
name2 address2........


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/