Is Patient Number / PT Number a common element between the two? In other
words, if there are two patients Dave F, each would have a unique Patient
Number/ PT Number, correct?

If this is correct, this type of problem is best solved with a database
program, such as Access, and not Excel. This requires creating a join
between these two tables on the basis of their shared data element, in this
case, the Patient Number.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"DavidK" wrote:

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


--
David K.