Transposing ~ 25,000 rows of data into Columns

I really could use some help here. I have ~25,000 rows of data, contact information, and I am trying to convert it to columns with the corresponding 9 column headers (Full Name, Job Title, Company, Business Street, Busines City, State, Business Phone, Business Fax, Web Page, E-Mail Address). The challenge is that each record does NOT have the same number of rows...?? I am new to this forum, so please forgive me if this a stupid question. I've attached the data for three records below and also in the attached spreadsheet.

Row Labels Data in Rows
Full Name Nick Strickland
Job Title Vice President
Company SC Products International
Business Street 11 Airport Road
Business City, State Redding, DE 96002-9217
Business Phone 800-555-4545
Business Fax 800-555-1234
Web Page www.vicepresident.com
E-Mail Address nick@vicepresident.com
Full Name Harry Parker
Company Supply Industries
Business Street 2166 South Flagler Ave.
Business City, State Yuma, AZ 85365-2420
Business Phone 800-555-4545
Business Fax 800-555-1234
Web Page www.peaceout.com
Job Title Gen. Mgr.
Company Handrew company
Business Street 40 Brookside Court
Business Street P. O. Box 12444
Business City, State Nader, WI 45668
Business Phone 800-555-4545
Business Fax 800-555-1234
Web Page www.hangtime.com
E-Mail Address dachtemeier@nbhandy.com

Hi strickrn,

welcome to the forum.

Is there an oversight in your data? I see only two names and the second name has two sets of addresses??

I understand your requirements. I was just wondering if the data sample you supplied contains errors, or if it is exemplary of the data you've got. We need to nail which row label serves as the indicator for a new record and if the Full Name may be missing, this must be taken into account.

So, if the company name is the trigger for a new record, does that mean that Harry Parker works for SC Products International?

This does not make sense.

Again: does your data sample contain errors, i.e. is there a Full Name missing betewen

Web Page www.peaceout.com

and

Job Title Gen. Mgr.

???

so, in terms of human logic, how would you determine which row label flags the new record if any of them can be missing? Can it be assumed that

- the row labels are always in the same order,
- this is also the order of the columns you have specified
- if a row label matches a column label, and that column label has already been filled in for the current record, then that means we're dealing with the next record?

Please confirm or correct the logic.

OK VBA experts, I've done all the spec work, now it's up to you for the coding ...

Here is a quick shot at the code.

Please Login or Register  to view this content.

there is a added column to deal with post office address. It look ok too me though i didnt look to close

i think this cracks it

Please Login or Register  to view this content.

probley not the most elegent way. Though as long as it works right.

cheers

no probs just double cheek everythink is going where it should be.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

What do you mean? Are you getting any error? Which post are you talking about?

It seems Arlette was asking a question...

What do you mean? Are you getting any error? Which post are you talking about?

...but rather you posted a question.

As per the forum rules, please start your own thread...