In col A I have a list of names with several blank cells between each name. The number of blank cells between each name can vary. In total I may have 500 names listed, covering a range of 3000+ cells.
I need to fill in the blank cells between names with the name preceding each small block of blanks, making a complete column of cells containing blocks of names. Thought it would be easy. I have tried to use a function/foumula in an adjacent blank column i.e. in col B but just get bogged down with TRUE FALSE responses and no real data. i.e.
Col A Col B
I would be grateful to know what function/foumula I can use consistenly in col B to fill in the blanks in Col 1 with the name at the top of each block of blank cells. I want Blanks 1,2 and 3 to equal Name1 and Blank 4 to equal Name 2 etc. I do not want to fill down each block of blanks manually. Any assistance woul be very much appreciated.