View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Sadie Sadie is offline
external usenet poster
 
Posts: 11
Default Multiple Row to columns

I know this seems so simple...maybe I'm now frustrated due to looking at the
computer screen all day. I am formulating an excel sheet as my data base to
create mail merge. The website that I have gotten the information from pastes
to the excel sheet as such:

File Numer 1233112 John Doe
12563 E Washington St
Mesa, AZ 85296

I need to date to read as following

File Number 1233112 John Doe 12563 E Washington St
Mesa, AZ 85296


Paste special does not work for this function and I have over 7,000 records
to sort through.... Please Help