#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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) |
#3
|
||||
|
||||
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. |
#4
|
||||
|
||||
deleted (duplicate post)
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Select all cells in a column , even when blank... | Chayes | Excel Programming | 4 | 05-30-2018 10:35 AM |
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 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 |