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: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
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