conditionally copying values down a column

[Excel Beginer]

Can anyone help me with the following?

I have a spreadsheet similar to below where I need to copy the transaction number down the column until the transaction number changes then repeat for the next transaction number

Record Number Transaction Date
Number
12321 100001 01/01/2011
12322
12323
12324
12325
12326
12327
12328
12329
12330
12331 100002 01/01/2011
12332
12333
12334
12335
12336
12337
12338
12339 100003 01/01/2011
12340
12341
12342
12343
12344
12345 100004 01/01/2011

[martindwilson]

???????????????? what should the result look like?

[royUK]

You could insert a "helper column" next to the existing column of numbers & blanks. Put the first number in at the top then this formula copied down from the cell below

=IF(A2="",B1,A2)

Copy & paste special the results as values, then delete the original column