formating sheet

  • Thread starter Thread starter Node321
  • Start date Start date
N

Node321

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
 
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
 
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.
 
Back
Top