formating sheet
 

i have one column that has three rows of info
name
street address, City, State Zipcode
phone number

how do i make it a column an input and a row for each name? like,
Name | Street Address | City | State | ZIPcode | Phone number

thanks in advanced



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

formating sheet
 

You are just trying to move data that is in mulitiple rows and single
column, to single row and multiple columns?

Then use Copy, PasteSpecial with Transpose:

Range("A1:A3").Select
Selection.Copy
Range("A4").Select
Selection.PasteSpecial Paste:=xlAll, Operation:=xlNone,
SkipBlanks:=False, Transpose:=True


On Fri, 19 Sep 2003 00:08:44 -0400, Node321
wrote:

i have one column that has three rows of info
name
street address, City, State Zipcode
phone number

how do i make it a column an input and a row for each name? like,
Name | Street Address | City | State | ZIPcode | Phone number

thanks in advanced



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

formating sheet
 

thanks
the thing is there are about 250 names
and i need it to to change from one column and three rows of info to
one row and 6 columns of info.



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