Filtering an Excel Report

C

Creds326

I save reports from Medical Mgr onto a UNIX server from which I then import
into Excel. Most reports I can format & even do pivot reports. However, some
of the reports are as follows:

Ref # Name/Address Phone Numbers ID Numbers Referrals
1 Doctor's Name Phone: ID1: PTD:
Street Address Fax: ID2:
YTD:
City, State, Zip Other: ID3:
UPIN:

The report contains over 3000 doctors. I want to be able to have the
following columns:

Ref # Name Address City, State, Zip ID1: ID2: ID3:
UPIN:

How do I get the various rows into the proper columns? And, most
importantly, that the info pertains to the proper doctor? I know that it can
be done because our back office in India does it but so far will not share
the directions with me. I just received another report with the above
columns with filter dropdowns. Any assistance would be greatly appreciated!
 
J

JP

Separating text into separate columns isn't some kind of secret. Just
go to Data > Text To Columns to split the doctor names and addresses
into separate columns.


HTH,
JP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top