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: 1
Default Moving cells in a column

I have some data that is all in order in a column, like this:

name 1
street 1
city 1
name 2
street 2
city 2
name 3
street 3
city 3

and i like to move the cells to look like this:
(Each in it's own cell for sorting)

name 1 street 1 city 1
name 2 street 2 city 2
name 3 street 3 city 3

without having to drag every single cell one at a time. I have over 2,500
cells and it would take too much work. My son is charging mee too much to do
it.(i should start charging him for rent and food)

What options do i have?

all help is really apreciated.




 
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
Arrow Keys Moving Window Frame instead of Moving Between Cells nemmex Excel Discussion (Misc queries) 2 April 9th 07 09:08 AM
moving alot of data (10000 cells) from a column to a row Paul Knight Excel Discussion (Misc queries) 3 August 21st 06 12:58 PM
Moving data from multiple cells to one column [email protected] Excel Discussion (Misc queries) 2 June 28th 06 02:15 AM
moving column/cell data to rows/cells fails Richard RE Excel Worksheet Functions 0 June 20th 06 06:05 AM
Why is my tab key moving my cursor from column A to column k? eterp05 Excel Discussion (Misc queries) 2 October 14th 05 07:17 PM


All times are GMT +1. The time now is 05:35 PM.

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

About Us

"It's about Microsoft Excel"