Search, concatenate, move, then delete

[dguenther]

Hi,

I am trouble doing the following in a macro:

OUTCOME: The court reversed the judgment of the district court. The court
remanded the question of the amount of costs to the district court for a further
remand to the arbitrators to make an appropriate award.
JUDGES:
*** [...***1] Joseph F. Baca, Justice. Dan Sosa, Jr., Chief Justice, Richard E.
Ransom, Justice, Kenneth B. Wilson, Justice, concur. Seth D. Montgomery,
Justice, Concurring in part, Dissenting in part. ...
2 of 27 DOCUMENTS
State v. Ybarra
No. 18,506
SUPREME COURT OF NEW MEXICO
111 N.M. 234; 804 P.2d 1053; 1990 N.M. LEXIS 415
November 28, 1990, Filed​

I need excel to:

(1) search for judges in the first row
(2) concatenate everything in the row(s) after judges and before the next line that starts with a number.
(3) move concatenated rows to G1
(4) delete "judges" and everything before it EXCEPT row 1



Thanks if you can help.

 

[hiker95]

dguenther,

What version of Excel are you using?

You will generally get much more help (and faster) in this forum if you can post your small samples (what you have and what you expect to achieve) directly in the forum.

To attach screenshots, see below in my Signature block: Post a screen shot with one of these:

 

[Rick Rothstein]

You showed us the "before" and gave us a description of what should be done, but it would be really helpful if you showed us the "after" so we can figure out exactly how your description should be carried out.

 

[dguenther]

Ok, hang tight- I'm taking some screenshots. Thanks

 

[dguenther]

 

[hiker95]

dguenther,

You are posting a picture. This means that if this was a problem where one needed to use your data, anyone trying to help you would have to enter the data manually. That makes no sense and I doubt that you would get any answer.

To attach screenshots, see below in my Signature block: Post a screen shot with one of these:

What version of Excel are you using?

 

[dguenther]

Ok, I'll try again. This is Excel 07 on windows 7 btw.

-Danny

 

[dguenther]

Here are links to

beginning product:
https://my.syncplicity.com/share/fg06cm2lxg/sample_begining.xlsm

and end product
https://my.syncplicity.com/share/u7be5l9mey/sample_finished.xlsm

 

[Rick Rothstein]

Are there merged cells in the first 6 rows of data (and in their repeated positions below)? If so, which cells make up the merge areas? Are the PROCEDURAL POSTURE text on separate rows like they appear to be? Same question for the JUDGES... are those three separate rows of data for the first group? And where did you want the output to go to.. a new page? It might be helpful for you to upload your file to one of the free file servers so we can download it and play with it directly.

You can post it online using one of these free posting websites...

Box: http://www.box.net/files
MediaFire: http://www.mediafire.com
FileFactory: http://www.filefactory.com
FileSavr: http://www.filesavr.com
FileDropper: http://www.filedropper.com
RapidShare: http://www.rapidshare.com

Then post the URL they give you for the file back here.

 

[dguenther]

Hi Rick (and thanks for the help!)

It's kind of strange, but everything is only in column A. each line is a different row. judges are unfortunately spread out through 3 rows.

To throw another stick in it, in subsequent parts of the document, judges might be 2 or even just 1 line.

But, the "category headers" (like judges, procedural posture) will always there.

And it will always be the first 5 rows after "1 of 27" (or whatever) that need to be put into the first five columns of the first row