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
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