simple question regarding pasting

[srosetti]

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

 

[Lars-Åke Aspelin]

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

If you don't have any formulas in column BA, just values, you may try
another helper column, say BZ.

In BZ1 you put the formula:

=IF(BP1="",BA1,BP1)

Copy column BZ and "Paste Special/Values" it to column BA.

Hope this helps / Lars-Åke

 

[srosetti]

I got to thinking after your suggestion and decided to make a true
entry of just displaying the data. Here is the new formula and works
great.

=IF(ISBLANK(BN2),BA2,BA2 & "," & BN2)

Maybe someone is doing something similar someday and could use this
formula.