Distributing info down for creating pivot table

The raw data I am using is quite long and in-depth and there are a couple of columns that I will be having to search through to copy the information in the cell down through a number of cells before it reaches the next cell in the column that has new data description.
Example, one product may be listed and then nothing in all the cells under it for the next 10 cells until a next product name is showing... Or a month is listed and no names of any months under it for 11 cells until it shows the next named month. This is going to be a very time consuming process. Isn't there some way of distributing the information down until it hits a cell that is populated with information and continuing this process on down? I saw a tutorial type video once upon a time that showed this function to "Distribute," but now for the life of me can't seem to find it again.
Other than someone replying and advising me to attach a spreadsheet as example, does anyone have any guidance?
Thank you sincerely for your time. ~Karen

Hi Karen,

Here's a method that I use.
Select all the cells in the column you want to populate.
On the home ribbon, go to Find & Select>Go To Special and choose Blanks.
Right click in the column and select Copy.
Type = then the up arrow
Hit Ctrl + Enter.

Hope that does the trick.
Dave

Dave (aka Flyboy65),
Thank you for the information, I may have been doing something wrong or a step was left off, but I couldn't get it to work.
No worries though, I was able to use the info recommended by another user and have success with this issue.
Thank you so much for your time.
Big virtual hug to you. ~Karen

Hi Ford,
Your instructions worked great and did the trick.
After making sure I knew what I was doing, I went into boss' office and asked, "Did you brush your teeth this morning?" She said, "Well, yes, of course" So, I said "Great, cause once I show you this you're gonna want to kiss me." ha ha. It was a joke only - and more good news, I'm not fired for saying that.
Showed the little tricky trick and she was very happy. Thanks for helping me get a brownie point with my boss!
Have a great day over there in PA.
~Karen