A
AetBridge
I have a provider directory with about 3,000 physicians that is set u
as a vertical list in excel. Each physician is set up as:
Physician's name(A)
Hospital(A) (only half of the listings have this line)
Address(A)
City, State, Zip(A)
Phone(A)
Provider ID #(A)
Gender(A)
Panal Status(A)
Physician's name(B)
Hospital(B) (only half of the listings have this line)
Address(B)
City, State, Zip(B)
Phone(B)
Provider ID #(B)
Gender(B)
Panal Status(B)
I need to transpose all of this information to get all of th
categories into columns like:
nameA HospitalA AddressA City,St,ZipA PhoneA ProviderA etc.
nameB HospitalA AddressB City,St,ZipB PhoneB ProviderB etc.
Is there a way to do all of these at once instead of manually doin
them?
The major problem that I see is that 1/2 of the 3000 listings have
lines and the other have 8 lines because not all of them have
hospital. However, every listing does end with the words "panal staus
on the last line (if that helps at all).
Can anyone assist me with this problem?
Thanks,
Bridget U
as a vertical list in excel. Each physician is set up as:
Physician's name(A)
Hospital(A) (only half of the listings have this line)
Address(A)
City, State, Zip(A)
Phone(A)
Provider ID #(A)
Gender(A)
Panal Status(A)
Physician's name(B)
Hospital(B) (only half of the listings have this line)
Address(B)
City, State, Zip(B)
Phone(B)
Provider ID #(B)
Gender(B)
Panal Status(B)
I need to transpose all of this information to get all of th
categories into columns like:
nameA HospitalA AddressA City,St,ZipA PhoneA ProviderA etc.
nameB HospitalA AddressB City,St,ZipB PhoneB ProviderB etc.
Is there a way to do all of these at once instead of manually doin
them?
The major problem that I see is that 1/2 of the 3000 listings have
lines and the other have 8 lines because not all of them have
hospital. However, every listing does end with the words "panal staus
on the last line (if that helps at all).
Can anyone assist me with this problem?
Thanks,
Bridget U