grouping rows

[mmcoordes]

Dear Forum,

I have a project that needs seperated so i can manage the results better. I am sure this is somewhere within this forum talked about or fixed but i am very limited on my excell knowledge. I have a database that extracts out to an excell file, what i need is the data "rows" between the "rec no" i.e.. 90 between 91 to be grouped. i need to do filters and the grouped rows need to move with filter. all this data is in there own rows. please HELP!!!

this is what my data looks like

column

A B C D

Rec No Record ID Miscellaneous Local Use
90 WP05 201007301 7/28/2010
Personnel Name Position Base Remarks
MLC LVL1 LGB READ \ GEORGE ONSITE VISIT SNA
91 WP05 201007305 7/29/2010
Personnel Name Position Base Remarks
MLC LVL1 LGB READ ORDER/ 2 VISUAL OCURRANCE
92 WP05 201007682 8/5/2010
Personnel Name Position Base Remarks
MLC LVL1 LGB RJ6 EXP EXH OP LIMITATIONS (GMM)
93 WP05 201007240
94 WP05 201007252
95 WP05 201007168
Personnel Name Position Base Remarks
SEE LVL1 LGB 201007168__________________________
96 WP05 201007205
Personnel Name Position Base Remarks
MLC LVL1 LGB LGB INCIDENT N713DS

[FDibbins]

try playing around with pivot tables.

if you still have a problem, perhaps it would be easier to help you if you uploaded a sample workbook, showing what data you are working with, a few examples of what your expected outcome would be, and how you would arrive at that (remove any confidential info if necessary).

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[FDibbins]

duplicate post

[mmcoordes]

wow, that was fast and i thank you. here is a small bit of the file.

forum list example.xls

[jaslake]

@ FDibbens
I see no indication this is a duplicate post...perhaps you deleted the other post. The OP's profile indicates only one started Thread.

@ mmcoordes
Please post examples of what you'd expect the output to look like.

[mmcoordes]

here is what i would like some 4000 records to look like, and will i be able to filter and sort eacg group?

thanks in advance

forum list example looklike.xls

[FDibbins]

@jaslake, the server hicupped and duplicated my own post, so i deleted the 2nd 1 lol, sorry for the confusion

[jaslake]

@FDibbens

I understand...been receiving duplicate emails re: responses to subscribed Threads. Thanks for the clarification.

[mmcoordes]

can someone please help. im desperate

[FDibbins]

where is this info coming from, and how are you pulling it in?

[mmcoordes]

This information is off my works database, it look great within it but the the system on allows a default export to excel. So for me to validate information from sources combined within the work database, this excel sheet would speed that process of validation by 10 fold. It is a great question because this data will change every time I export, I guess what I need is a macro to run each time I get a new spreadsheet.

Thanks again for the prompt replies, I really wish I had more in depth experience to excel.

[FDibbins]

i understand that some of this data may be sensitive, but if not, would it be possible to upload an exact copy of what the data looks like when you 1st get it?

[event21]

Hi -

Not sure if this is what you're looking for.

The output goes in sheet name "results", run the test macro in the first sheet.

Regards,
Event

[FDibbins]

see if this is something you can work with? on sheet2, column A, enter 90, 91, 92 etc downwards. then in B2, copied down and across, use this...

=IFERROR(INDEX('Records List Export'!$A$1:$M$38,MATCH(results!$A2,'Records List Export'!$A$1:$A$38,0),MATCH(results!B$1,'Records List Export'!$A$1:$K$1,0)),"")

[mmcoordes]

ok, here is the exact data i get of my data base, i used the help on one of the members post and that worked 95%. if you look some of the records have multiple lines of data attached to each individual record, i have no idea how to incororate that.

you forum peeps are the best!!!

forum as recieved data.xls

[mmcoordes]

i tried this, but nothing happened, so i probably did not follow the inteneded instructions.

[event21]

Hi -

The previous file is different from the new one.

What would you want for those records that has multiple Personnel,Position etc?

You need to define your requirement clearly.

Regards,
Event

[mmcoordes]

I apologize for the confusion, I will try and explain the best I can. My initial upload was to minimize the data size a be server friendly. What I'm after is the activity "#023" are to be compared to the "#024" so maybe better said is the #024 have information that ultimately gets transposed to #023 in the database. I need to validate all #024 data and compare it to #023.i hope I didn't confuse you all. Oh, and that's why the #023 has additional lines, that if you see has the long number relating to the #023. Thanks forum guru's for your help.

[event21]

I apologize for the confusion, I will try and explain the best I can. My initial upload was to minimize the data size a be server friendly. What I'm after is the activity "#023" are to be compared to the "#024" so maybe better said is the #024 have information that ultimately gets transposed to #023 in the database. I need to validate all #024 data and compare it to #023.i hope I didn't confuse you all. Oh, and that's why the #023 has additional lines, that if you see has the long number relating to the #023. Thanks forum guru's for your help.

Haha, it's really you're from spokane and I am in ph that's why we could not understand each other.

Sorry, I could not help

Regards,
Event