move cells up

[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

 

[Auric__]

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: [snip]
===============================================

Here's the result I'm looking for:

[snip again]

Your data got mangled by wordwrap. Put your data on pastebin.com (or a
similar site) and then post the resulting link here.

 

[gary c]

http://pastebin.com/KT7Q06Qa

 

[Auric__]

http://pastebin.com/KT7Q06Qa

[In the future, please quote the post you're replying to.]

If this is a one-time worry, I'd suggest doing it by hand, especially if
that's the entire spreadsheet you posted. You'd have it done in a minute or
two.

If not, go ahead and do another pastebin of how you want the data to end up.

(Do you really have unpaid taxes going back 40+ years?)

 

[gary c]

http://pastebin.com/KT7Q06Qa

[In the future, please quote the post you're replying to.]

If this is a one-time worry, I'd suggest doing it by hand, especially if
that's the entire spreadsheet you posted. You'd have it done in a minute or
two.

If not, go ahead and do another pastebin of how you want the data to end up.

(Do you really have unpaid taxes going back 40+ years?)

My spreadsheet has 400,000 rows. And "Yes", unpaid taxes go back to
1952.

 

[Auric__]

http://pastebin.com/KT7Q06Qa

[In the future, please quote the post you're replying to.]

If this is a one-time worry, I'd suggest doing it by hand, especially
if that's the entire spreadsheet you posted. You'd have it done in a
minute or two.

If not, go ahead and do another pastebin of how you want the data to
end up.

(Do you really have unpaid taxes going back 40+ years?)

My spreadsheet has 400,000 rows.

Ok, then I need another pastebin showing how you want things to end up.
(Wordwrap demolished *that*, too.)

And "Yes", unpaid taxes go back to 1952.

Yikes.

 

[gary c]

gary c wrote:
http://pastebin.com/KT7Q06Qa
[In the future, please quote the post you're replying to.]
If this is a one-time worry, I'd suggest doing it by hand, especially
if that's the entire spreadsheet you posted. You'd have it done in a
minute or two.
If not, go ahead and do another pastebin of how you want the data to
end up.
(Do you really have unpaid taxes going back 40+ years?)

My spreadsheet has 400,000 rows.

Ok, then I need another pastebin showing how you want things to end up.
(Wordwrap demolished *that*, too.)

And "Yes", unpaid taxes go back to 1952.

Yikes.

--
Before you complain, please consult your optic nerve,
as it has been sending me angry emails for years now.- Hide quoted text -

- Show quoted text -

I figured out how to do what I needed.

Thanks.