I know we've covered this already many many times.

Id like to do this with a twist:

I have a list of Data (may have seen another thread of mine) with
unique values. Say for example

Dog
Cat
..
Mouse
..
..
..
Kangaroo
..
..
..
..
..
Bear
Giraffe
..
Donkey
..
....Etc.

('.'s represent blank rows)

There is a lot of data out to the right side, and this data is listed
with one heading (ie. 'Kangaroo') to represent all of it until the next
heading. As I want to break this down, I want to list 'Kangaroo' beside
each row of data until the next listing (in this case, Bear), and so
on, to fill up all the blank rows.

Many thanks!