Help with AutoFill?

[Concat]

Hi, not sure how to solve this issue.

I have a large amount of data that I need help with.

it looks like this:


Person A NUMBER NUMBER
NUMBER NUMBER
NUMBER NUMBER
NUMBER NUMBER
NUMBER NUMBER

Person B NUMBER NUMBER
NUMBER NUMBER
NUMBER NUMBER

And I need it to look like this:

Person A NUMBER NUMBER
Person A NUMBER NUMBER
Person A NUMBER NUMBER
Person A NUMBER NUMBER
Person A NUMBER NUMBER

Person B NUMBER NUMBER
Person B NUMBER NUMBER
Person B NUMBER NUMBER



How do I accomplish without having to repeat the AutoFill process for each person? Doing that would be extremely tedious as I have 160 pages of data.

Sorry for the short message but I have to run. I also wasn't sure where to post this question. ANY advice would be beneficial.

I tried making an additional column with the formula: =IF(A2<>"",A2,A1)

Which DID work, but then I have two columns with names (can't delete adjacent column without adversly affecting formula?), and if I need to sort it (which I do) it gets all mucked up.

HELP! And thank you thank you thank you!


EDIT: The forum deleted my spaces.... but pretend that Person is under column A and the Numbers are COLUMN B, C etc.....

[royUK]

use the created column and then copy the whole column, then Edit >- PasteSpecial >- Values. Delete the original column

[oldchippy]

Hi Concat,

Welcome to the forum, if I understand you correctly you need to copy the person's name into the blank cells below in column A. If that is the case then try this

Select the range A1:A1000 (or whatever your range is), go to Edit > Go to > Special > Blanks
Click in the formula bar and type = then hit the up arrow
Then Ctrl+Enter key, the blank cells are now populated from the cell above
Then select column A, Copy, Paste Special > Values
Now you can sort and delete the names with blank cells next to them