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?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Copy cells in a column down to next non blank cell
- Thread starter bearly36
- Start date
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 90,541
- Office Version
- 365
- Platform
- Windows
Hi & welcome to MrExcel.
Have a look here Fill in blanks in Excel with value above/below, fill empty cells with 0 - Ablebits.com
Have a look here Fill in blanks in Excel with value above/below, fill empty cells with 0 - Ablebits.com
Upvote
0
Similar threads
- Solved
- Question
