Hi

With Row 1 being blank, and your data starting in A2, enter this formula in
C2
=IF(B2<"",B2,IF(A2=A1,C1,""))
Copy down as far as required.
Copy column CPaste SpecialValues back over column B
Column C can then be deleted.

Your sample data shows blank rows between each set of data. If that is only
to highlight the example posted, and the blanks do not exist in reality,
then you can achieve your desired result without formulae.

Highlight column BF5SpecialBlanksOKpress up arrowtype = and press up
arrowControl+Enter
All of the blank cells will be filled with the values from the cell above.
Once again, if you want to "fix" the data, Copy and paste SpecialValues
back over the original data.
--
Regards
Roger Govier

"colwyn" wrote in message
...
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.