Hi,

use an auxiliar column to do, assuming your data is an A and B

on C2 and D2 use =a2 and B2 respect..

on C3 =if(a3="",c2,a3) and =if(b3="",d2,b3) respect..

copy it down.

copy and paste special values to substitute the old A and B column

hth
regards from Brazil
Marcelo

"Jerome" escreveu:

Good day,

Could someone please help me with the following. I want to fill down
multiple cell contents within the same columns. There are over 12000 rows and
the columns vary from 2 or mo

A B
1 abc 123
2
3
4
5 def
6
7
8 ghi
9
10
11 jkl
12
13
14
15 mno
16
17
18
19 pqr

Thank you and best regards,

Jerome