LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 28
Default Changing Columns to Rows

I have a column of information. How can I move the data from the a cell in
the column into a cell in a row? For instance:

Currently
Steve Smith
1 some road
some town, CA, 555555
John Anderson
2 some blvd
this town, NY, 555555
John Doe
3 this pkwy
where, TX, 555555


What I want
Steve Smith 1 some road some town, CA 55555
John Anderson 2 some blvd this town, NY, 555555
John Doe 3 this pkway where, TX, 555555

Any help would be appreciated.

Thanks.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing from Rows to Columns RayH Excel Discussion (Misc queries) 3 July 23rd 06 05:34 AM
Changing Rows into Columns GaryG Excel Discussion (Misc queries) 12 April 21st 06 12:10 PM
Changing columns into rows Dave Excel Discussion (Misc queries) 3 April 5th 06 12:33 PM
Changing Columns to Rows jenbrunson Excel Discussion (Misc queries) 2 September 14th 05 03:31 PM
Changing Columns to Rows Question unknowndevice Excel Discussion (Misc queries) 1 August 26th 05 09:30 PM


All times are GMT +1. The time now is 07:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"