I am trying to figure out a formula that fills in blank cells by repeating the the contents of the above cell . The spreadsheet has several rows of data, a sample of the data is as follows:
Ref Name £
12 J Bloggs 1234
blank blank 2241
14 G Smith 3251
blank blank 3568
blank blank 5126
15 D Garry 1334

I am wanting have the following result but without having to manually copy and paste the Ref and Name down each time there is a gap:
Ref Name £
12 J Bloggs 1234
12 J Bloggs 2241
14 G Smith 3251
14 G Smith 3568
14 G Smith 5126
15 D Garry 1334

Does anybody know how to do it ?