Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 10-10-2017, 11:42 PM
ewso ewso is offline Windows 10 Office 2016
Advanced Beginner
 
Join Date: Nov 2016
Posts: 73
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!
Reply With Quote
  #2  
Old 10-11-2017, 12:27 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,660
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]
Reply With Quote
  #3  
Old 10-11-2017, 01:06 AM
ewso ewso is offline Windows 10 Office 2016
Advanced Beginner
 
Join Date: Nov 2016
Posts: 73
ewso is on a distinguished road
Default

so would there be a way to do what I'm asking by replicating the cells?
Reply With Quote
  #4  
Old 10-11-2017, 06:25 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Advanced Beginner
 
Join Date: May 2017
Posts: 86
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.
Reply With Quote
  #5  
Old 10-11-2017, 07:43 AM
xor xor is online now Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 789
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)
Reply With Quote
  #6  
Old 10-12-2017, 12:41 AM
ewso ewso is offline Windows 10 Office 2016
Advanced Beginner
 
Join Date: Nov 2016
Posts: 73
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?
Reply With Quote
  #7  
Old 10-12-2017, 01:09 AM
xor xor is online now Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 789
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.
Reply With Quote
  #8  
Old 10-12-2017, 03:27 AM
ewso ewso is offline Windows 10 Office 2016
Advanced Beginner
 
Join Date: Nov 2016
Posts: 73
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?
Reply With Quote
  #9  
Old 10-12-2017, 03:36 AM
xor xor is online now Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 789
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.
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 03:53 AM.


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