I am attempting to use Excel to fill in the blank cells in an organisational hierarchy I have. Before and After scenarios below.
I have attempted pseudocode on this.
For all rows
For all cells in row
If cell is populated, row++
If cell is not populated, copy the value immediately above to the...