I have a list of data that looks like this:

A B
1 123-45-6789 5.82
2
3 ---------------- -----
4 234-56-7890 9.53
5
6 ---------------- ------

I need it to look like this:

A B
1 123-45-6789 5.82
2 123-45-6789
3 ---------------- -----
4 234-56-7890 9.53
5 234-56-7890
6 ---------------- ------

I have never done a macro before, so a function would be great if possible.

Thank you in advance for any help!
Dawn