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