Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
Old 10-10-2017, 11:42 PM   #1
Advanced Beginner
 
Join Date: Nov 2016
Posts: 80
ewso is on a distinguished road
Default move cells automatically

Moderator..Please delete my post in the excel programming forum. Nobody knows how to do this with a macro over there so maybe I can get a way in this forum to do it without a macro. Thanks.



I have a table with two columns that looks like this..

Jeff...Rita
Lara..Sam
Kirk..Barry


I want to be able to move the names from the second column over to the first column and down one row so that it looks like this..

Jeff
Rita
Lara
Sam
Kirk
Barry


thanks for help!
ewso is offline   Reply With Quote
Old 10-11-2017, 12:27 AM   #2
Administrator
 
macropod's Avatar
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 17,029
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

You can't move content with a formula; you can only replicate it.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
macropod is offline   Reply With Quote
Old 10-11-2017, 01:06 AM   #3
Advanced Beginner
 
Join Date: Nov 2016
Posts: 80
ewso is on a distinguished road
Default

so would there be a way to do what I'm asking by replicating the cells?
ewso is offline   Reply With Quote
Old 10-11-2017, 06:25 AM   #4
Competent Performer
 
Join Date: May 2017
Posts: 116
ArviLaanemets is on a distinguished road
Default

1. You design a sheet with formulas to get wanted result;
2. You copy the range with formulas, and paste it to new (or same) location using PasteSpecial.Values option.
ArviLaanemets is offline   Reply With Quote
Old 10-11-2017, 07:43 AM   #5
xor
Expert
 
Join Date: Oct 2015
Posts: 832
xor is a jewel in the roughxor is a jewel in the roughxor is a jewel in the rough
Default

Maybe like the attached.
Attached Files
File Type: xlsx TwoColumnsToOne.xlsx (9.0 KB, 5 views)
xor is offline   Reply With Quote
Old 10-12-2017, 12:41 AM   #6
Advanced Beginner
 
Join Date: Nov 2016
Posts: 80
ewso is on a distinguished road
Default

Quote:
Originally Posted by xor View Post
Maybe like the attached.
xor..I opened the spreadsheet but I don't see a formula. what do I do with it?
ewso is offline   Reply With Quote
Old 10-12-2017, 01:09 AM   #7
xor
Expert
 
Join Date: Oct 2015
Posts: 832
xor is a jewel in the roughxor is a jewel in the roughxor is a jewel in the rough
Default

There are formulas in A12:A17.
xor is offline   Reply With Quote
Old 10-12-2017, 03:27 AM   #8
Advanced Beginner
 
Join Date: Nov 2016
Posts: 80
ewso is on a distinguished road
Default

okay I see the formula now. Can you tell me how I would adapt that to much bigger spreadsheets and with the names in different columns or rows?
ewso is offline   Reply With Quote
Old 10-12-2017, 03:36 AM   #9
xor
Expert
 
Join Date: Oct 2015
Posts: 832
xor is a jewel in the roughxor is a jewel in the roughxor is a jewel in the rough
Default

It would be much easier if you could upload a file with a reasonable set of sample data.
xor is offline   Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro to move cells ewso Excel Programming 1 10-11-2017 12:23 AM
any way to move cells automatically ewso Excel 2 10-10-2017 09:44 AM
how to move the box automatically when text moves ketanco Publisher 0 04-05-2016 09:00 AM
Linking cells: can sub-cells move with their master-cell when sorting? kw01 Excel 1 06-30-2015 05:02 PM
Automatically add something to cells SavvyEd Excel 2 07-31-2012 08:54 PM


All times are GMT -7. The time now is 04:18 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft