Thread: Copying column to another column with deleting date due to blank cells
View Single Post
 
Old 04-16-2023, 10:19 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 875
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