LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Frederique38
 
Posts: n/a
Default How can I automatically rearrange cells to my specifications?


I have data that is in three separate columns and I want to merge the
information into one column where the information would be identical to
reading it left to right in three columns. (Kind of like if I wanted to take
a page from a book and stack all the words vertically while maintaining their
order.) I'm trying to avoid simply repositioning each cell and was wondering
if there was any way it could be done automatically. If anyone could help it
would be much 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
I need formula that will automatically count the filled cells. Benar_Isais Excel Discussion (Misc queries) 2 November 15th 05 11:22 AM
Paste and automatically move cells Paul (ESI) Excel Discussion (Misc queries) 4 June 30th 05 02:31 PM
Pivot Tables: Can I get cells to duplicate downward automatically? StrawberryGirl Excel Discussion (Misc queries) 1 May 3rd 05 08:17 PM
automatically fill in a range of cells Maarten Excel Discussion (Misc queries) 1 April 29th 05 11:14 AM
Protected cells -automatically format to a different color Fred Evans Excel Discussion (Misc queries) 9 December 3rd 04 12:59 PM


All times are GMT +1. The time now is 10:10 AM.

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"