I have inherited a spreadsheet that does not have a Branch number in each
row. The data were entered so that the number is only in the first record
for each branch.) Looks like:
Branch # Employee Name
1243 Jones
Smith
Adams
1562 Johnson
Reilly

I think there is some way of getting the branch number to be on each row.
There are thousands of rpws and hundreds of branches. As I recall (dimly),
F5 is involved but numerous attempts have resulted in no solution.
As always your help is appreciated.

WAL50.