Transpose and Label

JimGunther

Board Regular
Joined
Oct 22, 2006
Messages
57
I have a very long list of names, titles and companies.
I THINK I'd like to transpose the data and add a label at the top
NOTE WELL every "record" is "anchored" by a PARAGRAPH mark in column A followed immediately by NAME in the next row in Column B .
While most records also have a COMPANY and TITLE as well as city state and country NOT ALL DO


Albert, Judy
Add Judy as contact
Send Message

ABC Company
Sr. Manager
Orlando
, FL
, United States


Arturo, James
Add James as contact
Send Message

The Good Co.
VP, Corporate Stuff
Portland
, OR
, United States


Alexander, William
Add William as contact
Send Message

STP Corporation
Corporate Treasurer
Mentor
, OH
, United States


Bernick, Julia
Add Julia as contact
Send Message

Amono Corp
Manager
Hosle
, Norway


Charlton, William
Add William as contact
Send Message

Halle Berry Co.
Safety Manager
Pennsauken
, NJ
, United States


Dexter, Dena
Add Dena as contact
Send Message

XYZ Corp
Director, Fun & Games
Rosemont
, IL
, United States


Fauntlerot, Christina
Add Christina as contact
Send Message

Yale University
Student
Philadelphia
, PA
, United States


Garland, Susan
Add Susan as contact
Send Message

Generous Motors
Director, Credit Cards
Akron
, OH
, United States



I tried to transpose using ASAP utilities but couldn't 'figger it
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

JimGunther

Board Regular
Joined
Oct 22, 2006
Messages
57
Sorry,
Earlier post may not have been clear.

I want to transpose Col A (for Labels) and Col B as Data

NOTE WELL Not every record (in Col B) contains exactly the same 10 (or 9) lines of Data. HOWEVER, there is a PARAGRAPH make between every record followed immediately by Contact.

PS: As soon as I can 'figger how to post the spreadsheet properly, I will do so.

TIA, Jim

Col A Col B

Contact Albert, Judy
First Add Judy as contact
Send Send Message
Blank1
Company ABC Company
Title Sr. Manager
City Orlando
State , FL
Country , United States
Blank2

Contact Arturo, James
First Add James as contact
Send Send Message
Blank1
Company The Good Co.
Title VP, Corporate Stuff
City Portland
State , OR
Country , United States
Blank2

Contact Alexander, William
First Add William as contact
Send Send Message
Blank1
Company STP Corporation
Title Corporate Treasurer
City Mentor
State , OH
Country , United States
Blank2

Contact Bernick, Julia
First Add Julia as contact
Send Send Message
Blank1
Company Amono Corp
Title Manager
City Hosle
State , Norway
Country

Contact Charlton, William
First Add William as contact
Send Send Message
Blank1
Company Halle Berry Co.
Title Safety Manager
City Pennsauken
State , NJ
Country , United States
Blank2

Contact Dexter, Dena
First Add Dena as contact
Send Send Message
Blank1
Company XYZ Corp
Title Director, Fun & Games
City Rosemont
State , IL
Country , United States
Blank2

Contact Fauntlerot, Christina
First Add Christina as contact
Send Send Message
Blank1
Company Yale University
Title Student
City Philadelphia
State , PA
Country , United States
Blank2

Contact Garland, Susan
First Add Susan as contact
Send Send Message
Blank1
Company Generous Motors
Title Director, Credit Cards
City Akron
State , OH
Country , United States
Blank2
 

Watch MrExcel Video

Forum statistics

Threads
1,122,206
Messages
5,594,833
Members
413,943
Latest member
Dhornsby21

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top