G
gary c
How can I move the cell containing "paid status" and the cell
containing the first "70-nnnn" up to the same row as the preceding
cell containing "ASSESSMENT NO"?
Here's my spreadsheet:
a
b c
ASSESSMENT NO
70-0012
70-0015
70-0016
paid
status
ASSESSMENT NO
70-0012
70-0015
paid
status
ASSESSMENT NO
70-0012
70-0015
paid
status
ASSESSMENT NO
70-0012
70-0015
paid
status
ASSESSMENT NO
70-0012
70-0015
paid
status
ASSESSMENT NO
70-0012
70-0015
paid
status
ASSESSMENT NO
70-0012
70-0015
70-0016
70-0060
paid
status
ASSESSMENT NO
70-0012
70-0015
paid
status
ASSESSMENT NO
70-0012
70-0015
paid
status
ASSESSMENT NO
70-0012
70-0015
paid
status
ASSESSMENT NO
70-0012
70-0015
paid
status
ASSESSMENT NO
70-0012
70-0015
paid
status
ASSESSMENT NO
70-0012
70-0015
paid
status
ASSESSMENT NO
70-0012
70-0015
paid
status
ASSESSMENT NO
70-0012
70-0015
paid
status
ASSESSMENT NO
70-0012
70-0015
paid
status
ASSESSMENT NO
70-0012
70-0015
paid
status
===============================================
Here's the result I'm looking for:
a
b c
ASSESSMENT NO paid status 70-0012
70-0015
70-0016
ASSESSMENT NO paid status 70-0012
70-0015
ASSESSMENT NO paid status 70-0012
70-0015
ASSESSMENT NO paid status 70-0012
70-0015
ASSESSMENT NO paid status 70-0012
70-0015
ASSESSMENT NO paid status 70-0012
70-0015
ASSESSMENT NO paid status 70-0012
70-0015
70-0016
70-0060
ASSESSMENT NO paid status 70-0012
70-0015
ASSESSMENT NO paid status 70-0012
70-0015
ASSESSMENT NO paid status 70-0012
70-0015
ASSESSMENT NO paid status 70-0012
70-0015
ASSESSMENT NO paid status 70-0012
70-0015
ASSESSMENT NO paid status 70-0012
70-0015
ASSESSMENT NO paid status 70-0012
70-0015
ASSESSMENT NO paid status 70-0012
70-0015
ASSESSMENT NO paid status 70-0012
70-0015
ASSESSMENT NO paid status 70-0012
70-0015
containing the first "70-nnnn" up to the same row as the preceding
cell containing "ASSESSMENT NO"?
Here's my spreadsheet:
a
b c
ASSESSMENT NO
70-0012
70-0015
70-0016
paid
status
ASSESSMENT NO
70-0012
70-0015
paid
status
ASSESSMENT NO
70-0012
70-0015
paid
status
ASSESSMENT NO
70-0012
70-0015
paid
status
ASSESSMENT NO
70-0012
70-0015
paid
status
ASSESSMENT NO
70-0012
70-0015
paid
status
ASSESSMENT NO
70-0012
70-0015
70-0016
70-0060
paid
status
ASSESSMENT NO
70-0012
70-0015
paid
status
ASSESSMENT NO
70-0012
70-0015
paid
status
ASSESSMENT NO
70-0012
70-0015
paid
status
ASSESSMENT NO
70-0012
70-0015
paid
status
ASSESSMENT NO
70-0012
70-0015
paid
status
ASSESSMENT NO
70-0012
70-0015
paid
status
ASSESSMENT NO
70-0012
70-0015
paid
status
ASSESSMENT NO
70-0012
70-0015
paid
status
ASSESSMENT NO
70-0012
70-0015
paid
status
ASSESSMENT NO
70-0012
70-0015
paid
status
===============================================
Here's the result I'm looking for:
a
b c
ASSESSMENT NO paid status 70-0012
70-0015
70-0016
ASSESSMENT NO paid status 70-0012
70-0015
ASSESSMENT NO paid status 70-0012
70-0015
ASSESSMENT NO paid status 70-0012
70-0015
ASSESSMENT NO paid status 70-0012
70-0015
ASSESSMENT NO paid status 70-0012
70-0015
ASSESSMENT NO paid status 70-0012
70-0015
70-0016
70-0060
ASSESSMENT NO paid status 70-0012
70-0015
ASSESSMENT NO paid status 70-0012
70-0015
ASSESSMENT NO paid status 70-0012
70-0015
ASSESSMENT NO paid status 70-0012
70-0015
ASSESSMENT NO paid status 70-0012
70-0015
ASSESSMENT NO paid status 70-0012
70-0015
ASSESSMENT NO paid status 70-0012
70-0015
ASSESSMENT NO paid status 70-0012
70-0015
ASSESSMENT NO paid status 70-0012
70-0015
ASSESSMENT NO paid status 70-0012
70-0015