Copy and paste per ID number

[MissPucca]

Hi there,

I have a rather large dataset (originally over 48,000 rows) in Excel. In the first column, I have ID numbers. Since the data was entered on per event basis, several rows may belong to the same ID. In another column (labelled "Tx_days"), I used an IF-formula such that the cell in that column belonging to the last row of each ID contains a value in that column and the preceding cells do not contain values (I used "" for this in the IF-formula). I would like to copy the value in those cells to the preceding blank cells per ID. However, since my dataset is very large, I would prefer not to have to copy the value to the blank cells one by one. Could anyone please help me with this?

To be a bit more clear, I would like to go from:
1
1
1
1 200

to this:
1 200
1 200
1 200
1 200

for each ID.

Any help would very much be appreciated!

[antoka05]

You can use the first free column to insert formulas and put, in the last cell (i.e. E33314), the formula:

=D33314

while in other cells, i.e. E2:E3313, put the formula:

=IF(D33313="",E33314,D33313)

Regards,
Antonio

[MissPucca]

Thank you very much, Antonio! I applied the formula in the way you suggested and it worked. Your help really saved me a lot of work, so thanks once again!