Combine Rows of Data into one Row Excel 2010

[nickbanta]

Hello I have an issue I was inquiring if this could be easily solved.

My business I work for is a collection agency and from time to time our clients send us files that are beyond recognizable for our collection software to understand nonetheless import into our database.

The file was a PDF at first but I have since been able to convert to excel format.

The data isn't too scrambled just scattered throughout rows. I would like to have rows of patient data into one row.

The file after being converted was all in row A but I have since used text to columns to divide into separate rows. However now one patient information is on multiple rows and I need each patient info on one row.

The file looks like:

|A---------|B-------|C----------|
1.John-----|Doe-----|123 Main St|
2.New York-|NY------|
3.11100----|SSN----|Balance Owed|

I would like the data from multiple rows to continue on row 1 like this:

|A--------|B-----|C------------|D----------|E--|F-----|G----|H-------------|
1.John----|Doe---|123 Main St.-|New York---|NY-|11100|SSN-|Balance Owed--|


I am no programmer in the least and have very little to no experience in pivot tables.

This file has about 7000 accounts with patient info spread through 3-4 rows for each set of data.

Does anybody have an idea how I could go about doing this without manually copying and pasting into additional columns on the same row. That will take hours if not days. Any Help will be greatly appreciated.

Apologies for all of the dashes as I am attempting to mimic a spreadsheet and spacing went away in the preview and I wanted to properly demonstrate what I needed so ignore the dashes.

Thanks again.

[lampje77]

Ok, i am supposing each set of clientdata is followed by an empty row. In that case I found the following for you

example.png
create an auto filter in column N and select 1.
Hope this is what you need

[nickbanta]

Thanks. I will give this a shot and see if it works out