making vertical data horizontal?

[deesh123]

I am trying to take info that copies into a column to convert to a row

When i copy an address from the webpage it displays like this

Name
1234 Address Street
Phone(123) 345-9876

I want it to read like this (as a row, each data in differen
columns):

Name | 1234 Address Street | Phone(123) 345-9876

-dou

 

[hce]

Hi

You can copy and Paste as Special - Transpose...

Cheer

 

[Jason Morin]

If your data starts in A1, put this in B1, fill the
formula horizontally to D1, then copy down:

=OFFSET($A$1,ROW()*3-5+COLUMN(),)

HTH
Jason
Atlanta, GA

 

[mzehr]

Doug

Try copying the data, then use edit, paste special,
transpose.

 

[deesh123]

where can i find transpose

 

[David McRitchie]

select, copy (ctrl+v)
select one cell that is not within the previous selection
Edit, paste special,l transpose.

There is also a transpose available in macros.

Also once you have a hint at an answer you can look for
Transpose in HELP, and/or you can look for Transpose
in the Newsgroup archives, probably would have found
something, then again as you there are newsgroups..
http://www.mvps.org/dmcritchie/excel/xlnews.htm

You might also want to look at my pages
http://www.mvps.org/dmcritchie/excel/snakecols.htm
if you want to do more than set of name and address at a time.

 

[deesh123]

http://www.mvps.org/dmcritchie/excel/snakecols.htm

this link does not work

thanks for your help

-dou

 

[deesh123]

Ok I tried your transpose method and it worked great.

My next question is this:

My data looks like this when I paste

Bob Smith
1234 Address Street
Town, City 90210
(123) 456-7890

Joe Smith
3333 Fake Street
Town, City 90210
(123) 456-7890

How can I get it to look like this (in 1 or as few steps as possible)

Bob Smith|1234 Address Street|Town, City 90210|(123) 456-7890
Joe Smith |3333 Fake Street| Town, City 90210 |(123) 456-7890

It is the same problem, but this time with multiple entries

Thanks for your help so far!

-Doug :

 

[David McRitchie]

Hi Doug,
Had an "s" on the end the corrected link below fill answer the
question you just asked with more than one name.
http://www.mvps.org/dmcritchie/excel/snakecol.htm

 

[deesh123]

I have a slightly new delimma now.

My data reads like this:

Name McName
(123) 456-8949 1000 Adress Ave
Washington, DC

Is there a way I can snake the information as I did before as well a
split the phone number and address so it will look like this:

Name McName|(123)456-8949|1000 Adress Ave|Washington, DC

Let me know

-dou

 

[David McRitchie]

Hi Doug,
Then do as before ??

You don't give enough information.
Is the Name, phone, address, town
on separate rows or all in one cell

If on separate rows use the snake columns to separate
then insert a column before the Town column and
use SepTerm from
http://www.mvps.org/dmcritchie/excel/join.htm#SepTerm
to split on the first space, since it looks like there are no spaces
within the phone number.
--

 

[deesh123]

I am sorry I wasn't clear enough.

The difference this time is that the name is in row one
the phone and address are in row two and the city is in row 3.

Name McName
(123) 456-8949 1000 Adress Ave
Washington, DC

Is it possible to snake the rows into four columns, splitting the 2nd
row into two columns?

Does this make sense? Its a tricky question to ask.

-doug

thanks for your help

 

[David McRitchie]

And that is the situation that I gave for my last reply.
Didn't it work.
Creating a Table from something like a column of address labels (#snkAddr)
http://www.mvps.org/dmcritchie/excel/snakecol#snkAddr

Then you split of the phone number from a column as previously described.
Worry about this when you get the above done.


HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm