move cells up

  • Thread starter Thread starter gary c
  • Start date Start date
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
 
gary said:
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:
Click to expand...
[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 said:
http://pastebin.com/KT7Q06Qa
Click to expand...

[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 said:
http://pastebin.com/KT7Q06Qa
Click to expand...

[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?)
Click to expand...

My spreadsheet has 400,000 rows. And "Yes", unpaid taxes go back to
1952.
 
gary said:
gary said:
http://pastebin.com/KT7Q06Qa
Click to expand...

[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?)
Click to expand...

My spreadsheet has 400,000 rows.
Click to expand...

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.
Click to expand...

Yikes.
 
gary said:
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?)
Click to expand...
Click to expand...
My spreadsheet has 400,000 rows.
Click to expand...

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.
Click to expand...

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 -
Click to expand...

I figured out how to do what I needed.

Thanks.
 
Back
Top