Distributing information down when building a 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? Thank you for your time. ~Karen

Hold down the Ctrl button and hit the down arrow button.

Karen,

If you haven't already found a solution to your predicament, try this link:
http://blog.contextures.com/archives...ue-from-above/
I think it's what you were looking for.

Dave