I have received a very weird data file, that looks somewhat like pivot. I need to flatten that file with "Fill From Above" approach. This ideally could have been easy with normal "fill from above" (i.e. [Ctrl+G] > Special > "Select Blanks" > Write a formula to fill previous row cell > [Ctrl+Enter] ), but in this occassion, as I have highlighted in the attached screenshot----- Not in all cases it should copy down the data from valued cell above, rather it should leave those cells empty, otherwise whole data representation will be wrong.
Could someone help please? Any VBA code etc?
Please try to give me a generic solution instead of going by codes with specific hard coding etc.
Pivot.JPG
Bookmarks