I have two columns. BA and BP

BA has data in every row all the way down

BP has data in most of the cells, but some are blank utilizing a
formula of =IF(ISBLANK(BN7),"",BA7 & "," & BN7) Column BP is merely a
helper column to append data together if BN is empty just leave it
blank otherwise populate BP with BA and B7 data

Now I need to copy all of the rows that have data in column BP and
paste them over the top of the entries that exist in BA basically
replacing the data. since some of the rows in Column of BP are empty
I want to skip pasting blank entries over the top of BA leaving the
original data.

There are thousands of entries in this spreadsheet so going in bunches
or 1 by 1 would take forever. I tried to paste special skip blanks,
but it didn't give me the desired result..it still cleared data in BA
when BP was blank.

Thanks