I want to copy past a formula in an adjacent cell
and drag it down for all records in the adjacent cell.

There are thousands of records
Is there a way of selecting and pasting only the cells that has data in it..
rather than selecting the whole column and pasting it?