Not sure if Auto/Flashfill can do this, but here goes.
I have a column of data which displays a type and then blanks and then another type and then more blanks. Instead of blanks, I want it to simply display the most recent type.
Column A is the source data, Column C is what I want it to look like.
It seems simple, but how do you do this?
Thanks!
Last edited by mikeczyz; 09-15-2017 at 02:14 PM. Reason: clarification
In C2, try
=IF(A2="",C1,A2)
copied down column C.
If you don't want to use a helper column, you can put =A2 in A3 and then select A3 > Copy > select column A > Find & Select > Go to special > Blanks > OK
Right-click on any of the selected blank cells > Paste
Then you can copy and paste column A as values to get rid of the formulas.
omg, i knew i was missing something totally obvious. thanks!
Happy to help, thanks for the rep!
If that solved your question, please mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks