Easiest way is probably to use a spare column  to hold a filled-in name.

Assume ... name is in column A; cells without names are empty; if the cell
is empty, then take the name from the previous cell  that is not empty; spare
column is G.

=IF(A5="",G4,A5)

If this is copied down G, it'll bring names across, or look up to the
previous row  for a value.

You can then auto-filter on G.

Now this isn't a copy, it's a formula. E.g. you can't delete a row without
mucking things up.

If you want, though, you can select all of column G, then
copy/paste-special-values to get rid of the formulas.

Not sure why you'd look for Post Code being blank. If that's significant,
then this simple formula won't cater for it.

If I send you what we get off the scheduler and what it needs to look like would
that be OK?

I understand the vertical search  for the StaffName. What is a bit fuzzy is; when
'horizontally' do I know there is data for the PostCode? Are the cell  contents
'blank' or 'empty' untill there is data for the StaffName?
Please advise.

Here is an example of what we get from our scheduler the amount of jobs can vary
so the staff names are not always in the same place.

020708Unfiltered.

And this is how i want it to end up.

020708Filtered.

So my macro then need to set up as an add-in so our back office can run this
before it is sent out to the team leaders.

I have blanked the address's with xx