Multiple Rows to One Row

**_Ryan_** · 07-02-2010, 03:25 PM

I have a spreadsheet that has patient information and each patient has multiple rows because they have multiple different diagnosis and/or procedure codes. I want each patient to have one row and each diagnosis, procedure, etc is in its own cell/column. There can be up to 30 Diagnosis codes and 30 Procedure codes for one patient. Each patient has a unique ID number, which is what I would want to base the pivot on, but each patient can have a different number of diagnosis/procedure codes.

Please help! I've tried a pivot table, which wont get me one row per patient.

Thanks in advance!

**JBeaucaire** · 07-02-2010, 08:59 PM

'COLUMN DATA TO ROW DATA
I have a macro that may be "ready to use" for merging rows of data to one row matching for column A.

Columns to Rows - Part 2

**_Ryan_** · 07-06-2010, 10:20 AM

Your macro seems like it will be perfect and exactly what I am trying to do. I tried pasting it into my file and I got a "Run Time Error '1004': Method 'Range' of object '_Global' failed." When I go to the Debugger, it highlights this:

Please Login or Register  to view this content.

How can I fix that?

**JBeaucaire** · 07-06-2010, 12:47 PM

A couple of lines of code above that the LastRow variable was resolved by searching column A for the last cell with data. The line of code you've noted is simply the delRNG seeding itself on an empty row so that it can be easily added to later.

There's nothing wrong with the code, used it many times, so there must be something in your workbook you haven't explained yet.

Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your workbook. We'll look at it together. Make sure the macro is already installed.