One of your pieces of data is "missing" a phone number... how many phone
number columns will there be (one with both phone numbers in a single cell,
two with the missing phone number shown as an empty cell in the second phone
number column, three in case there is ever a third phone number, something
else)? Can any of the other data ever be missing? If so, will there
**always** be an email address?

Rick


"Dendy" wrote in message
...
How can I put the following information into an excel spreadsheet with the
information going across the sheet other than copy, paste special,
transpose
with each one

Maurine Allen
7475 Skillman St #D-103
Dallas TX USA 75231
Achieva International

(214) 823-9500
(214) 823-9514
Meeting Management Professional
Melissa Allen
3220 Coolidge Highway
Berkley MI USA 48072
Mission Point Resort

248-291-8871
248-542-3868
Supplier Meeting Professional
Micah Allen
105 E. Pascagoula St., Suite 2
Jackson MS USA 39207
Jackson Convention Complex/SMG

601-383-4454
Supplier Meeting Professional
Micki Allen
345 Renfrew Dr #101
Markham ON CAN L3R 9S9
MARAC Enterprises

(905) 474-9118
(905) 474-1968
Corporate Meeting Professional