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

test ex.xlsx (9.7 KB, 3 views)

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
and copy it down. Then copy the results, and use PasteSpecial.Values to overwrite column G

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.

deleted (duplicate post)