G
Guest
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.
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.