Hi,

You need a helper column.

In C1 enter the formula =B1
In C2 enter the formula
=IF(A2=A1,C1,B2)

Drag down as required.

Hide column B. Alternatively, copy Column C and paste it back over itself
using
Paste Special - paste values and then delete Column B

Mike

"colwyn" wrote:

I have Excel 2007.

There is one sheet with 2 columns of data.

Column one has a series of numbers (e.g, 111,22,3333,etc).
Column 2 has a series of terms (e.g, work,gym,home,etc).

My problem is: whereas there is a series of numbers in column 1, the
terms in column 2 only appear on the first row of each of these column
1 series.

1 work
1
1

2 gym
2

3 shop
3
3
3

I want the terms to appear every time alongside each column 1 number.

1 work
1 work
1 work

2 gym
2 gym

3 shop
3 shop
3 shop
3 shop


Can anyone supply a formula which I can put in column 3 which I can
fill down to provide the desired effect??
Big thanks.
Colwyn.