Fill in all the blanks
When you get reports, you sometimes need to ‘fix’ them so that you have no blanks and each line has all the information. Below a report, but we need to fill in the blanks i.e. London should appear in A3 to A7. We could spend all day copy and pasting each one down or else we can use the GOTO Special tool.
See below, all the blank cells are told to look at the cell above it and you have the blanks filled in.
To see the full course contents click here.