Mike -

Assuming the Headers as described below are in cells A1 and B1 and the Data
begins in Cell A2, then

1.) Enter the following formula in Cell C2:

=IF(A2<"",A2,OFFSET(C2,-1,0))

2.) Copy the formula down column C to match the last row of data in Column A

3.) Select and Copy the cells with the data in Column C

4.) Select Cell A2, right click -- Paste Special -- Select 'Values' --
click Okay

Matt

"MikeD1224" wrote:

I have some data that looks like this:

Store Account #
1 4201
4203
4204
5 4201
4203
4204

I eventually want it to look like this:

Store Account #
1 4201
1 4203
1 4204
5 4201
5 4203
5 4204

I'm hoping to avoid doing it by hand. Is there a macro I can record or
write that will accomplish this? Thanks for the help in advance.