D
DavidK
I have been given two seperate spread sheets that the data needs to be
joined. This data has been from a Hospital program that doesn't allow the
information to be on one report. Therefore, there are two seperate
spreadsheets which when combined would reflect a patient's visit. There is a
field in each spread sheet that is the same data although the field is
labeled differently. In Table 1 the field is called Patient Number and in
Table 2 it is called PT Number. However this number can appear more than once
in each spread sheet. This number appears more than once because the patient
has more than one form of Insurance. If I combine these spread sheets and
then sort by PT Number (copied the Patient Number from table 1 to that area)
I then have all the information I need, but I need to combine the rows. For
example, I may have up to four rows of one patient's information if they have
to types of insurance. In that case, I have all of the information for table
1 filled in two rows out of the 4 but the information for table 2 is empty. I
will then have 2 rows filled in for table 2 and two rows for table one are
empty. When these spread sheets are combined there are over 45,000 rows. I
am not certain I have explained this well but I would be happy to answer any
questions. I need help.
Table 1 contain the following labels.
Patient Name
Patient Number
FC
Ins1
Acct Type
Admit Diag
Drg
Table 2 has the following labels
Plan Code
Insurance Company
Employer
Ins Policy Number
Group Number
Subscriber Group ID
PT Number
Admit Date
Physician Number
Total Charges
joined. This data has been from a Hospital program that doesn't allow the
information to be on one report. Therefore, there are two seperate
spreadsheets which when combined would reflect a patient's visit. There is a
field in each spread sheet that is the same data although the field is
labeled differently. In Table 1 the field is called Patient Number and in
Table 2 it is called PT Number. However this number can appear more than once
in each spread sheet. This number appears more than once because the patient
has more than one form of Insurance. If I combine these spread sheets and
then sort by PT Number (copied the Patient Number from table 1 to that area)
I then have all the information I need, but I need to combine the rows. For
example, I may have up to four rows of one patient's information if they have
to types of insurance. In that case, I have all of the information for table
1 filled in two rows out of the 4 but the information for table 2 is empty. I
will then have 2 rows filled in for table 2 and two rows for table one are
empty. When these spread sheets are combined there are over 45,000 rows. I
am not certain I have explained this well but I would be happy to answer any
questions. I need help.
Table 1 contain the following labels.
Patient Name
Patient Number
FC
Ins1
Acct Type
Admit Diag
Drg
Table 2 has the following labels
Plan Code
Insurance Company
Employer
Ins Policy Number
Group Number
Subscriber Group ID
PT Number
Admit Date
Physician Number
Total Charges