Controlled or Custom Autofill

[milikien]

Hello, Does anyone have a suggestion on how I can complete a special type of autofill? I'm not sure how to describe it or if there is a name for it. The only thing I can do is show it......I get a large report that I can sort and manipulate but I have to go through a lengthy process of filling in all the holes before I can start. It looks something like this:
____A_______B____
Name #1 Product #1
________Product #2
________Product #3
Name #2 Product #1
________Product #3
Name #3 Product #2
________Product #4
________Product #5
________Product #6
Name #4 Product #1
________Product #4

and so on... What I currently do is a manual autofill on each name to add the name on each row below it (either by dragging or double clicking). Is there any easier way? The end product should look like this:

Name #1 Product #1
Name #1 Product #2
Name #1 Product #3
Name #2 Product #1
Name #2 Product #3
Name #3 Product #2
Name #3 Product #4
Name #3 Product #5
Name #3 Product #6
Name #4 Product #1
Name #4 Product #4

Please note that not all names have the same amount of products. I'm thinking some sort of macro might work but I'm not sure how to set that up. Thanks for any suggestions.

 

[Jonmo1]

Welcome to the board.

Highlight column A
Click Edit - Goto - Special - Blanks - OK
Press =
Press UP Arrow
Press CTRL + ENTER

Highlight column A again
Right Click - Copy
Right Click - Paste Special - Values - OK


Hope that helps.

 

[VoG]

Select column A, press F5, click Special, tick Blanks, click OK

Press =

Press Up arrow

Hold down CTRL and press Enter

 

[milikien]

Thank you very much...both of you!