I have a spreadsheet that has data in A2. The data in columns B- K corresponds to the label in A2 and goes down to K 365. However A3 to A365 are blank so I am not able to filter correctly. I only get the data in A2. There is a new label in A366 which corresponds to data down through K570 but A367-A569 are blank. Is there a formula that will populate those blank cells in column A …taking the data in A2 and pasting it in A3-A365, then Taking the data in A366 and pasting it in A367 to A568? Basically, filling in the blanks in between the data with the data that’s above it?