Thread: Copying column to another column with deleting date due to blank cells
View Single Post
 
Old 04-18-2023, 06:10 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
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