K
Ken
Is there a single command that will fill each blank cell below a cell
with a number with that same number? There are 435 numbers and
different numbers of blank cells (including none) below each number.
A portion of the table is shown below. I want, e.g., the cell below 1
to show 1, the two cells below 2 to show 2, the two cells below 3 to
show 3 - and because there is no blank below four, move on to the next
1, etc.
Ken
AR 1 BERRY, MARION
AR HUMPHREY, VERNON WOO
AR 2 GARNER, ED
AR PARKS, MARVIN
AR SNYDER, VICTOR F
AR 3 BOOZMAN, JOHN NICHOL
AR JUDY, JANICE (JAN) A
AR MORFEY, DALE WILLIAM
AR 4 ROSS, MICHAEL A
CA 1 MEYERS, WILLIAM P
CA THOMPSON, MIKE
CA WIESNER, LAWRENCE R
CA 2 HERGER, WALTER WILLI
CA VANCE, JEFFREY PAUL
CA 3 CASTILLO, GABRIEL E
CA LUNGREN, DANIEL E
CA OLLER, THOMAS R
CA OSE, MARY
CA TUMA, DOUGLAS ARTHUR
with a number with that same number? There are 435 numbers and
different numbers of blank cells (including none) below each number.
A portion of the table is shown below. I want, e.g., the cell below 1
to show 1, the two cells below 2 to show 2, the two cells below 3 to
show 3 - and because there is no blank below four, move on to the next
1, etc.
Ken
AR 1 BERRY, MARION
AR HUMPHREY, VERNON WOO
AR 2 GARNER, ED
AR PARKS, MARVIN
AR SNYDER, VICTOR F
AR 3 BOOZMAN, JOHN NICHOL
AR JUDY, JANICE (JAN) A
AR MORFEY, DALE WILLIAM
AR 4 ROSS, MICHAEL A
CA 1 MEYERS, WILLIAM P
CA THOMPSON, MIKE
CA WIESNER, LAWRENCE R
CA 2 HERGER, WALTER WILLI
CA VANCE, JEFFREY PAUL
CA 3 CASTILLO, GABRIEL E
CA LUNGREN, DANIEL E
CA OLLER, THOMAS R
CA OSE, MARY
CA TUMA, DOUGLAS ARTHUR