Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-16-2023, 12:20 PM
Sportsmen Sportsmen is offline Copying column to another column with deleting date due to blank cells Windows 10 Copying column to another column with deleting date due to blank cells Office 2019
Novice
Copying column to another column with deleting date due to blank cells
 
Join Date: Nov 2022
Posts: 8
Sportsmen is on a distinguished road
Default Copying column to another column with deleting date due to blank cells


So I have 2 columns. I want to cut all the data from column H/Local and paste it into G/rating. However, I do not want the blanks from column H to delete data in G. I could alt and click on the cells in this example, but I need to be bale to do this with thousands of cells so I was hoping to figure out an easier way.

Thanks again for the help!

The 2nd I post on here I figure it out. Sorry for bothering you guys.
Attached Files
File Type: xlsx test ex.xlsx (9.7 KB, 1 views)
Reply With Quote
  #2  
Old 04-16-2023, 10:19 PM
ArviLaanemets ArviLaanemets is offline Copying column to another column with deleting date due to blank cells Windows 8 Copying column to another column with deleting date due to blank cells Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

When your data are starting from row 2 (e.g. row 1 being header):
Into some free column (e.g. X) into row 2 enter formula like
Code:
=IF(H2="","" & G2,H2)
and copy it down. Then copy the results, and use PasteSpecial.Values to overwrite column G
Reply With Quote
  #3  
Old 04-18-2023, 06:10 AM
p45cal's Avatar
p45cal p45cal is offline Copying column to another column with deleting date due to blank cells Windows 10 Copying column to another column with deleting date due to blank cells Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Copy column H2:H53 (Ctrl+c)
Select G2, Paste Special… tick the Skip Blanks checkbox, OK.


2023-04-18_140917.png


It won't let you cut and paste special, so you'll have to delete column H afterwards.
Reply With Quote
  #4  
Old 04-18-2023, 06:16 AM
p45cal's Avatar
p45cal p45cal is offline Copying column to another column with deleting date due to blank cells Windows 10 Copying column to another column with deleting date due to blank cells Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

deleted (duplicate post)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying column to another column with deleting date due to blank cells Select all cells in a column , even when blank... Chayes Excel Programming 4 05-30-2018 10:35 AM
Copying column to another column with deleting date due to blank cells Vlookup fill down blank cells in column mbesspiata Excel Programming 8 09-26-2016 04:44 AM
Auto Fill only Blank Cells in a Column mbesspiata3 Excel Programming 1 09-22-2016 07:18 PM
Copying column to another column with deleting date due to blank cells Copying DNA from web and need to convert column date to ex: 11-15 JacMUr2 Excel 2 01-22-2016 03:36 AM
Return Sum value of one column from cells not blank in another column zulugandalf Excel 3 08-14-2014 03:37 AM

Other Forums: Access Forums

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


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft