Reorganizing rows and columns in excel

tabihussain

New Member
Joined
Oct 24, 2017
Messages
6
Hi there,
I really hope someone has a solution for this problem. I want to analyze data from a clinical lab in SPSS. The data I have has several thousand samples, so I want an easy way of transferring it in SPSS for analysis. Here is a screenshot of the data. Now the problem is against one patient, efficacy to a panel of drugs is tested and between patients, the panel of drugs that is tested can also vary. The data is pasted below. The left most column is the sample ID number as you can see the same ID number prevails for about 13 cases, so this is one patient's result. My problem is I want to export this data in spss in a way that all the drugs (Amikacin, Ampicillin etc etc) become variables (columns), each with values 1,0 etc for one patient, so that all data for one ID number/patient is limited to one row only. Is there any way to reorganize this data? If not a shortcut, at least less tedious than manually copying all rows for one ID? I would want the conversion to somewhat like the second table.
I would really appreciate any ideas.
Best Regards
Tabi

[TABLE="width: 783"]
<tbody>[TR]
[TD="align: right"]14423230[/TD]
[TD="align: right"]05:50.7[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]80[/TD]
[TD]Y[/TD]
[TD]Urine For C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Amikacin[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423230[/TD]
[TD="align: right"]05:50.7[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]80[/TD]
[TD]Y[/TD]
[TD]Urine For C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Amoxicillin + Clavulanic acid[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423230[/TD]
[TD="align: right"]05:50.7[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]80[/TD]
[TD]Y[/TD]
[TD]Urine For C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Ampicillin[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423230[/TD]
[TD="align: right"]05:50.7[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]80[/TD]
[TD]Y[/TD]
[TD]Urine For C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Ceftriaxone[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423230[/TD]
[TD="align: right"]05:50.7[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]80[/TD]
[TD]Y[/TD]
[TD]Urine For C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Ciprofloxacin[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423230[/TD]
[TD="align: right"]05:50.7[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]80[/TD]
[TD]Y[/TD]
[TD]Urine For C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Cotrimoxazole[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423230[/TD]
[TD="align: right"]05:50.7[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]80[/TD]
[TD]Y[/TD]
[TD]Urine For C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Fosfomycin[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD="align: right"]14423230[/TD]
[TD="align: right"]05:50.7[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]80[/TD]
[TD]Y[/TD]
[TD]Urine For C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Gentamicin[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423230[/TD]
[TD="align: right"]05:50.7[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]80[/TD]
[TD]Y[/TD]
[TD]Urine For C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Imipenem[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423230[/TD]
[TD="align: right"]05:50.7[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]80[/TD]
[TD]Y[/TD]
[TD]Urine For C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Meropenem[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423230[/TD]
[TD="align: right"]05:50.7[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]80[/TD]
[TD]Y[/TD]
[TD]Urine For C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Nitrofurantoin[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423230[/TD]
[TD="align: right"]05:50.7[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]80[/TD]
[TD]Y[/TD]
[TD]Urine For C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Piperacillin+Tazobactam[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423230[/TD]
[TD="align: right"]05:50.7[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]80[/TD]
[TD]Y[/TD]
[TD]Urine For C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Sulzone[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423279[/TD]
[TD="align: right"]40:50.3[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]55[/TD]
[TD]Y[/TD]
[TD]NBL for C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Doxycycline[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD="align: right"]14423279[/TD]
[TD="align: right"]40:50.3[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]55[/TD]
[TD]Y[/TD]
[TD]NBL for C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Gentamicin[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423279[/TD]
[TD="align: right"]40:50.3[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]55[/TD]
[TD]Y[/TD]
[TD]NBL for C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Meropenem[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423279[/TD]
[TD="align: right"]40:50.3[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]55[/TD]
[TD]Y[/TD]
[TD]NBL for C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Amikacin[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423279[/TD]
[TD="align: right"]40:50.3[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]55[/TD]
[TD]Y[/TD]
[TD]NBL for C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Polymyxin B[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD="align: right"]14423279[/TD]
[TD="align: right"]40:50.3[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]55[/TD]
[TD]Y[/TD]
[TD]NBL for C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Cotrimoxazole[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD="align: right"]14423279[/TD]
[TD="align: right"]40:50.3[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]55[/TD]
[TD]Y[/TD]
[TD]NBL for C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Tigecycline[/TD]
[TD]I[/TD]
[/TR]
[TR]
[TD="align: right"]14423279[/TD]
[TD="align: right"]40:50.3[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]55[/TD]
[TD]Y[/TD]
[TD]NBL for C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Amoxicillin + Clavulanic acid[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423279[/TD]
[TD="align: right"]40:50.3[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]55[/TD]
[TD]Y[/TD]
[TD]NBL for C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Ceftriaxone[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423279[/TD]
[TD="align: right"]40:50.3[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]55[/TD]
[TD]Y[/TD]
[TD]NBL for C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Imipenem[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423279[/TD]
[TD="align: right"]40:50.3[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]55[/TD]
[TD]Y[/TD]
[TD]NBL for C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Ampicillin[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423279[/TD]
[TD="align: right"]40:50.3[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]55[/TD]
[TD]Y[/TD]
[TD]NBL for C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Ciprofloxacin[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423279[/TD]
[TD="align: right"]40:50.3[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]55[/TD]
[TD]Y[/TD]
[TD]NBL for C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Sulzone[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423279[/TD]
[TD="align: right"]40:50.3[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]55[/TD]
[TD]Y[/TD]
[TD]NBL for C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Piperacillin+Tazobactam[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423316[/TD]
[TD="align: right"]21:01.9[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]60[/TD]
[TD]Y[/TD]
[TD]Fluid For C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Cotrimoxazole[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423316[/TD]
[TD="align: right"]21:01.9[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]60[/TD]
[TD]Y[/TD]
[TD]Fluid For C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Ceftriaxone[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423316[/TD]
[TD="align: right"]21:01.9[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]60[/TD]
[TD]Y[/TD]
[TD]Fluid For C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Piperacillin+Tazobactam[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD="align: right"]14423316[/TD]
[TD="align: right"]21:01.9[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]60[/TD]
[TD]Y[/TD]
[TD]Fluid For C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Amikacin[/TD]
[TD]I[/TD]
[/TR]
[TR]
[TD="align: right"]14423316[/TD]
[TD="align: right"]21:01.9[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]60[/TD]
[TD]Y[/TD]
[TD]Fluid For C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Amoxicillin + Clavulanic acid[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423316[/TD]
[TD="align: right"]21:01.9[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]60[/TD]
[TD]Y[/TD]
[TD]Fluid For C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Ciprofloxacin[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423316[/TD]
[TD="align: right"]21:01.9[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]60[/TD]
[TD]Y[/TD]
[TD]Fluid For C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Tigecycline[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD="align: right"]14423316[/TD]
[TD="align: right"]21:01.9[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]60[/TD]
[TD]Y[/TD]
[TD]Fluid For C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Sulzone[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423316[/TD]
[TD="align: right"]21:01.9[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]60[/TD]
[TD]Y[/TD]
[TD]Fluid For C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Doxycycline[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423316[/TD]
[TD="align: right"]21:01.9[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]60[/TD]
[TD]Y[/TD]
[TD]Fluid For C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Gentamicin[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423316[/TD]
[TD="align: right"]21:01.9[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]60[/TD]
[TD]Y[/TD]
[TD]Fluid For C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Imipenem[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD="align: right"]14423316[/TD]
[TD="align: right"]21:01.9[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]60[/TD]
[TD]Y[/TD]
[TD]Fluid For C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Meropenem[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD="align: right"]14423316[/TD]
[TD="align: right"]21:01.9[/TD]
[TD]***[/TD]
[TD]M[/TD]
[TD="align: right"]60[/TD]
[TD]Y[/TD]
[TD]Fluid For C/S[/TD]
[TD]Klebsiella pneumoniae[/TD]
[TD]Ampicillin[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423680[/TD]
[TD="align: right"]36:02.2[/TD]
[TD]*[/TD]
[TD]M[/TD]
[TD="align: right"]12[/TD]
[TD]D[/TD]
[TD]Pus for C/S[/TD]
[TD]Klebsiella oxytoca[/TD]
[TD]Tigecycline[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD="align: right"]14423680[/TD]
[TD="align: right"]36:02.2[/TD]
[TD]*[/TD]
[TD]M[/TD]
[TD="align: right"]12[/TD]
[TD]D[/TD]
[TD]Pus for C/S[/TD]
[TD]Klebsiella oxytoca[/TD]
[TD]Doxycycline[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423680[/TD]
[TD="align: right"]36:02.2[/TD]
[TD]*[/TD]
[TD]M[/TD]
[TD="align: right"]12[/TD]
[TD]D[/TD]
[TD]Pus for C/S[/TD]
[TD]Klebsiella oxytoca[/TD]
[TD]Ciprofloxacin[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423680[/TD]
[TD="align: right"]36:02.2[/TD]
[TD]*[/TD]
[TD]M[/TD]
[TD="align: right"]12[/TD]
[TD]D[/TD]
[TD]Pus for C/S[/TD]
[TD]Klebsiella oxytoca[/TD]
[TD]Gentamicin[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423680[/TD]
[TD="align: right"]36:02.2[/TD]
[TD]*[/TD]
[TD]M[/TD]
[TD="align: right"]12[/TD]
[TD]D[/TD]
[TD]Pus for C/S[/TD]
[TD]Klebsiella oxytoca[/TD]
[TD]Amikacin[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD="align: right"]14423680[/TD]
[TD="align: right"]36:02.2[/TD]
[TD]*[/TD]
[TD]M[/TD]
[TD="align: right"]12[/TD]
[TD]D[/TD]
[TD]Pus for C/S[/TD]
[TD]Klebsiella oxytoca[/TD]
[TD]Piperacillin+Tazobactam[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD="align: right"]14423680[/TD]
[TD="align: right"]36:02.2[/TD]
[TD]*[/TD]
[TD]M[/TD]
[TD="align: right"]12[/TD]
[TD]D[/TD]
[TD]Pus for C/S[/TD]
[TD]Klebsiella oxytoca[/TD]
[TD]Meropenem[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD="align: right"]14423680[/TD]
[TD="align: right"]36:02.2[/TD]
[TD]*[/TD]
[TD]M[/TD]
[TD="align: right"]12[/TD]
[TD]D[/TD]
[TD]Pus for C/S[/TD]
[TD]Klebsiella oxytoca[/TD]
[TD]Amoxicillin + Clavulanic acid[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423680[/TD]
[TD="align: right"]36:02.2[/TD]
[TD]*[/TD]
[TD]M[/TD]
[TD="align: right"]12[/TD]
[TD]D[/TD]
[TD]Pus for C/S[/TD]
[TD]Klebsiella oxytoca[/TD]
[TD]Ceftriaxone[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]14423680[/TD]
[TD="align: right"]36:02.2[/TD]
[TD]*[/TD]
[TD]M[/TD]
[TD="align: right"]12[/TD]
[TD]D[/TD]
[TD]Pus for C/S[/TD]
[TD]Klebsiella oxytoca[/TD]
[TD]Sulzone[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD="align: right"]14423680[/TD]
[TD="align: right"]36:02.2[/TD]
[TD]*[/TD]
[TD]M[/TD]
[TD="align: right"]12[/TD]
[TD]D[/TD]
[TD]Pus for C/S[/TD]
[TD]Klebsiella oxytoca[/TD]
[TD]Imipenem[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD="align: right"]14423680[/TD]
[TD="align: right"]36:02.2[/TD]
[TD]*[/TD]
[TD]M[/TD]
[TD="align: right"]12[/TD]
[TD]D[/TD]
[TD]Pus for C/S[/TD]
[TD]Klebsiella oxytoca[/TD]
[TD]Cotrimoxazole[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Intended Output
[TABLE="width: 1408"]
<colgroup><col width="64" span="22" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]ID number[/TD]
[TD="width: 64"]Age[/TD]
[TD="width: 64"]Gender[/TD]
[TD="width: 64"]Isolate[/TD]
[TD="width: 64"]Amikacin[/TD]
[TD="width: 64"]Amoxicillin + Clavulanic acid[/TD]
[TD="width: 64"]Ampicillin[/TD]
[TD="width: 64"]Ceftriaxone[/TD]
[TD="width: 64"]Cefipime[/TD]
[TD="width: 64"]Ceftazidine[/TD]
[TD="width: 64"]Sulzone[/TD]
[TD="width: 64"]Tigecycline[/TD]
[TD="width: 64"]Ciprofloxacin[/TD]
[TD="width: 64"]Cotrimoxazole[/TD]
[TD="width: 64"]Doxycycline[/TD]
[TD="width: 64"]Fosfomycin[/TD]
[TD="width: 64"]Gentamicin[/TD]
[TD="width: 64"]Imipenem[/TD]
[TD="width: 64"]Meropenem[/TD]
[TD="width: 64"]Nitrofurantoin[/TD]
[TD="width: 64"]Piperacillin+Tazobactam[/TD]
[TD="width: 64"]Polymyxin B[/TD]
[/TR]
[TR]
[TD="align: right"]14423230[/TD]
[TD="align: right"]80[/TD]
[TD]M[/TD]
[TD]Klebsiella [/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]S[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[/TR]
</tbody>[/TABLE]
 
Hi
Sorry to bother you again but I am having some trouble with the code. I realized that the same ID number duplicates for different tests. This happens in cases where one person is infected with more than one bacteria. These entries should be made separately, perhaps by adding a,b,c at the end of the ID number. Can this be done? The total isolates that appear in the complete list have more variations than those appearing in the 8th column here.

Here is sample data, you can see first few IDs have multiple results which I want to sort w.r.t column 8.
[TABLE="width: 742"]
<tbody>[TR]
[TD="align: right"]13040745[/TD]
[TD="align: right"]26:27.4[/TD]
[TD="align: left"]Hameeda Begum[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]65[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Escherichia coli[/TD]
[TD="align: left"]Doxycycline[/TD]
[TD="align: left"]R[/TD]
[/TR]
[TR]
[TD="align: right"]13040745[/TD]
[TD="align: right"]26:27.4[/TD]
[TD="align: left"]Hameeda Begum[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]65[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Escherichia coli[/TD]
[TD="align: left"]Ciprofloxacin[/TD]
[TD="align: left"]R[/TD]
[/TR]
[TR]
[TD="align: right"]13040745[/TD]
[TD="align: right"]26:27.4[/TD]
[TD="align: left"]Hameeda Begum[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]65[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Escherichia coli[/TD]
[TD="align: left"]Gentamicin[/TD]
[TD="align: left"]R[/TD]
[/TR]
[TR]
[TD="align: right"]13040745[/TD]
[TD="align: right"]26:27.4[/TD]
[TD="align: left"]Hameeda Begum[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]65[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Escherichia coli[/TD]
[TD="align: left"]Ampicillin[/TD]
[TD="align: left"]R[/TD]
[/TR]
[TR]
[TD="align: right"]13040745[/TD]
[TD="align: right"]26:27.4[/TD]
[TD="align: left"]Hameeda Begum[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]65[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Escherichia coli[/TD]
[TD="align: left"]Tigecycline[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13040745[/TD]
[TD="align: right"]26:27.4[/TD]
[TD="align: left"]Hameeda Begum[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]65[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Escherichia coli[/TD]
[TD="align: left"]Sulzone[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13040745[/TD]
[TD="align: right"]26:27.4[/TD]
[TD="align: left"]Hameeda Begum[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]65[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Escherichia coli[/TD]
[TD="align: left"]Amikacin[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13040745[/TD]
[TD="align: right"]26:27.4[/TD]
[TD="align: left"]Hameeda Begum[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]65[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Escherichia coli[/TD]
[TD="align: left"]Amoxicillin_Clavulanic acid[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13040745[/TD]
[TD="align: right"]26:27.4[/TD]
[TD="align: left"]Hameeda Begum[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]65[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Escherichia coli[/TD]
[TD="align: left"]Cotrimoxazole[/TD]
[TD="align: left"]R[/TD]
[/TR]
[TR]
[TD="align: right"]13040745[/TD]
[TD="align: right"]26:27.4[/TD]
[TD="align: left"]Hameeda Begum[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]65[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Escherichia coli[/TD]
[TD="align: left"]Meropenem[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13040745[/TD]
[TD="align: right"]26:27.4[/TD]
[TD="align: left"]Hameeda Begum[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]65[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Escherichia coli[/TD]
[TD="align: left"]Imipenem[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13040745[/TD]
[TD="align: right"]26:27.4[/TD]
[TD="align: left"]Hameeda Begum[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]65[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Escherichia coli[/TD]
[TD="align: left"]Ceftriaxone[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13040745[/TD]
[TD="align: right"]26:27.4[/TD]
[TD="align: left"]Hameeda Begum[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]65[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Escherichia coli[/TD]
[TD="align: left"]Piperacillin_Tazobactam[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13040745[/TD]
[TD="align: right"]26:27.4[/TD]
[TD="align: left"]Hameeda Begum[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]65[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Pseudomonas aeruginosa[/TD]
[TD="align: left"]Piperacillin_Tazobactam[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13040745[/TD]
[TD="align: right"]26:27.4[/TD]
[TD="align: left"]Hameeda Begum[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]65[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Pseudomonas aeruginosa[/TD]
[TD="align: left"]Amikacin[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13040745[/TD]
[TD="align: right"]26:27.4[/TD]
[TD="align: left"]Hameeda Begum[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]65[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Pseudomonas aeruginosa[/TD]
[TD="align: left"]Gentamicin[/TD]
[TD="align: left"]R[/TD]
[/TR]
[TR]
[TD="align: right"]13040745[/TD]
[TD="align: right"]26:27.4[/TD]
[TD="align: left"]Hameeda Begum[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]65[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Pseudomonas aeruginosa[/TD]
[TD="align: left"]Sulzone[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13040745[/TD]
[TD="align: right"]26:27.4[/TD]
[TD="align: left"]Hameeda Begum[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]65[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Pseudomonas aeruginosa[/TD]
[TD="align: left"]Ceftazidime[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13040745[/TD]
[TD="align: right"]26:27.4[/TD]
[TD="align: left"]Hameeda Begum[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]65[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Pseudomonas aeruginosa[/TD]
[TD="align: left"]Aztreonam[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13040745[/TD]
[TD="align: right"]26:27.4[/TD]
[TD="align: left"]Hameeda Begum[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]65[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Pseudomonas aeruginosa[/TD]
[TD="align: left"]Cefepime[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13040745[/TD]
[TD="align: right"]26:27.4[/TD]
[TD="align: left"]Hameeda Begum[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]65[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Pseudomonas aeruginosa[/TD]
[TD="align: left"]Imipenem[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13040745[/TD]
[TD="align: right"]26:27.4[/TD]
[TD="align: left"]Hameeda Begum[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]65[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Pseudomonas aeruginosa[/TD]
[TD="align: left"]Meropenem[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13040745[/TD]
[TD="align: right"]26:27.4[/TD]
[TD="align: left"]Hameeda Begum[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]65[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Pseudomonas aeruginosa[/TD]
[TD="align: left"]Ciprofloxacin[/TD]
[TD="align: left"]R[/TD]
[/TR]
[TR]
[TD="align: right"]13043130[/TD]
[TD="align: right"]32:57.1[/TD]
[TD="align: left"]Fazal Subhan[/TD]
[TD="align: left"]M[/TD]
[TD="align: right"]55[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Klebsiella pneumoniae[/TD]
[TD="align: left"]Imipenem[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13043130[/TD]
[TD="align: right"]32:57.1[/TD]
[TD="align: left"]Fazal Subhan[/TD]
[TD="align: left"]M[/TD]
[TD="align: right"]55[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Klebsiella pneumoniae[/TD]
[TD="align: left"]Sulzone[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13043130[/TD]
[TD="align: right"]32:57.1[/TD]
[TD="align: left"]Fazal Subhan[/TD]
[TD="align: left"]M[/TD]
[TD="align: right"]55[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Klebsiella pneumoniae[/TD]
[TD="align: left"]Ampicillin[/TD]
[TD="align: left"]R[/TD]
[/TR]
[TR]
[TD="align: right"]13043130[/TD]
[TD="align: right"]32:57.1[/TD]
[TD="align: left"]Fazal Subhan[/TD]
[TD="align: left"]M[/TD]
[TD="align: right"]55[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Klebsiella pneumoniae[/TD]
[TD="align: left"]Gentamicin[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13043130[/TD]
[TD="align: right"]32:57.1[/TD]
[TD="align: left"]Fazal Subhan[/TD]
[TD="align: left"]M[/TD]
[TD="align: right"]55[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Klebsiella pneumoniae[/TD]
[TD="align: left"]Meropenem[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13043130[/TD]
[TD="align: right"]32:57.1[/TD]
[TD="align: left"]Fazal Subhan[/TD]
[TD="align: left"]M[/TD]
[TD="align: right"]55[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Klebsiella pneumoniae[/TD]
[TD="align: left"]Tigecycline[/TD]
[TD="align: left"]I[/TD]
[/TR]
[TR]
[TD="align: right"]13043130[/TD]
[TD="align: right"]32:57.1[/TD]
[TD="align: left"]Fazal Subhan[/TD]
[TD="align: left"]M[/TD]
[TD="align: right"]55[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Klebsiella pneumoniae[/TD]
[TD="align: left"]Ciprofloxacin[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13043130[/TD]
[TD="align: right"]32:57.1[/TD]
[TD="align: left"]Fazal Subhan[/TD]
[TD="align: left"]M[/TD]
[TD="align: right"]55[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Klebsiella pneumoniae[/TD]
[TD="align: left"]Amikacin[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13043130[/TD]
[TD="align: right"]32:57.1[/TD]
[TD="align: left"]Fazal Subhan[/TD]
[TD="align: left"]M[/TD]
[TD="align: right"]55[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Klebsiella pneumoniae[/TD]
[TD="align: left"]Amoxicillin_Clavulanic acid[/TD]
[TD="align: left"]R[/TD]
[/TR]
[TR]
[TD="align: right"]13043130[/TD]
[TD="align: right"]32:57.1[/TD]
[TD="align: left"]Fazal Subhan[/TD]
[TD="align: left"]M[/TD]
[TD="align: right"]55[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Klebsiella pneumoniae[/TD]
[TD="align: left"]Cotrimoxazole[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13043130[/TD]
[TD="align: right"]32:57.1[/TD]
[TD="align: left"]Fazal Subhan[/TD]
[TD="align: left"]M[/TD]
[TD="align: right"]55[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Klebsiella pneumoniae[/TD]
[TD="align: left"]Doxycycline[/TD]
[TD="align: left"]R[/TD]
[/TR]
[TR]
[TD="align: right"]13043130[/TD]
[TD="align: right"]32:57.1[/TD]
[TD="align: left"]Fazal Subhan[/TD]
[TD="align: left"]M[/TD]
[TD="align: right"]55[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Klebsiella pneumoniae[/TD]
[TD="align: left"]Piperacillin_Tazobactam[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13043130[/TD]
[TD="align: right"]32:57.1[/TD]
[TD="align: left"]Fazal Subhan[/TD]
[TD="align: left"]M[/TD]
[TD="align: right"]55[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Pseudomonas aeruginosa[/TD]
[TD="align: left"]Amikacin[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13043130[/TD]
[TD="align: right"]32:57.1[/TD]
[TD="align: left"]Fazal Subhan[/TD]
[TD="align: left"]M[/TD]
[TD="align: right"]55[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Pseudomonas aeruginosa[/TD]
[TD="align: left"]Ciprofloxacin[/TD]
[TD="align: left"]R[/TD]
[/TR]
[TR]
[TD="align: right"]13043130[/TD]
[TD="align: right"]32:57.1[/TD]
[TD="align: left"]Fazal Subhan[/TD]
[TD="align: left"]M[/TD]
[TD="align: right"]55[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Pseudomonas aeruginosa[/TD]
[TD="align: left"]Gentamicin[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13043130[/TD]
[TD="align: right"]32:57.1[/TD]
[TD="align: left"]Fazal Subhan[/TD]
[TD="align: left"]M[/TD]
[TD="align: right"]55[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Pseudomonas aeruginosa[/TD]
[TD="align: left"]Imipenem[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13043130[/TD]
[TD="align: right"]32:57.1[/TD]
[TD="align: left"]Fazal Subhan[/TD]
[TD="align: left"]M[/TD]
[TD="align: right"]55[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Pseudomonas aeruginosa[/TD]
[TD="align: left"]Cefepime[/TD]
[TD="align: left"]R[/TD]
[/TR]
[TR]
[TD="align: right"]13043130[/TD]
[TD="align: right"]32:57.1[/TD]
[TD="align: left"]Fazal Subhan[/TD]
[TD="align: left"]M[/TD]
[TD="align: right"]55[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Pseudomonas aeruginosa[/TD]
[TD="align: left"]Meropenem[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13043130[/TD]
[TD="align: right"]32:57.1[/TD]
[TD="align: left"]Fazal Subhan[/TD]
[TD="align: left"]M[/TD]
[TD="align: right"]55[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Pseudomonas aeruginosa[/TD]
[TD="align: left"]Aztreonam[/TD]
[TD="align: left"]R[/TD]
[/TR]
[TR]
[TD="align: right"]13043130[/TD]
[TD="align: right"]32:57.1[/TD]
[TD="align: left"]Fazal Subhan[/TD]
[TD="align: left"]M[/TD]
[TD="align: right"]55[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Pseudomonas aeruginosa[/TD]
[TD="align: left"]Ceftazidime[/TD]
[TD="align: left"]R[/TD]
[/TR]
[TR]
[TD="align: right"]13043130[/TD]
[TD="align: right"]32:57.1[/TD]
[TD="align: left"]Fazal Subhan[/TD]
[TD="align: left"]M[/TD]
[TD="align: right"]55[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Pseudomonas aeruginosa[/TD]
[TD="align: left"]Sulzone[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13043130[/TD]
[TD="align: right"]32:57.1[/TD]
[TD="align: left"]Fazal Subhan[/TD]
[TD="align: left"]M[/TD]
[TD="align: right"]55[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Pseudomonas aeruginosa[/TD]
[TD="align: left"]Piperacillin_Tazobactam[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13009399[/TD]
[TD="align: right"]44:16.0[/TD]
[TD="align: left"]***[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]72[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Escherichia coli[/TD]
[TD="align: left"]Ciprofloxacin[/TD]
[TD="align: left"]R[/TD]
[/TR]
[TR]
[TD="align: right"]13009399[/TD]
[TD="align: right"]44:16.0[/TD]
[TD="align: left"]***[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]72[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Escherichia coli[/TD]
[TD="align: left"]Amikacin[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13009399[/TD]
[TD="align: right"]44:16.0[/TD]
[TD="align: left"]***[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]72[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Escherichia coli[/TD]
[TD="align: left"]Ceftriaxone[/TD]
[TD="align: left"]R[/TD]
[/TR]
[TR]
[TD="align: right"]13009399[/TD]
[TD="align: right"]44:16.0[/TD]
[TD="align: left"]***[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]72[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Escherichia coli[/TD]
[TD="align: left"]Cotrimoxazole[/TD]
[TD="align: left"]R[/TD]
[/TR]
[TR]
[TD="align: right"]13009399[/TD]
[TD="align: right"]44:16.0[/TD]
[TD="align: left"]***[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]72[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Escherichia coli[/TD]
[TD="align: left"]Tigecycline[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13009399[/TD]
[TD="align: right"]44:16.0[/TD]
[TD="align: left"]***[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]72[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Escherichia coli[/TD]
[TD="align: left"]Imipenem[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13009399[/TD]
[TD="align: right"]44:16.0[/TD]
[TD="align: left"]***[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]72[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Escherichia coli[/TD]
[TD="align: left"]Amoxicillin_Clavulanic acid[/TD]
[TD="align: left"]R[/TD]
[/TR]
[TR]
[TD="align: right"]13009399[/TD]
[TD="align: right"]44:16.0[/TD]
[TD="align: left"]***[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]72[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Escherichia coli[/TD]
[TD="align: left"]Piperacillin_Tazobactam[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13009399[/TD]
[TD="align: right"]44:16.0[/TD]
[TD="align: left"]***[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]72[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Escherichia coli[/TD]
[TD="align: left"]Sulzone[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"]13009399[/TD]
[TD="align: right"]44:16.0[/TD]
[TD="align: left"]***[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]72[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Escherichia coli[/TD]
[TD="align: left"]Gentamicin[/TD]
[TD="align: left"]R[/TD]
[/TR]
[TR]
[TD="align: right"]13009399[/TD]
[TD="align: right"]44:16.0[/TD]
[TD="align: left"]***[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]72[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Escherichia coli[/TD]
[TD="align: left"]Ampicillin[/TD]
[TD="align: left"]R[/TD]
[/TR]
[TR]
[TD="align: right"]13009399[/TD]
[TD="align: right"]44:16.0[/TD]
[TD="align: left"]***[/TD]
[TD="align: left"]F[/TD]
[TD="align: right"]72[/TD]
[TD="align: left"]Y[/TD]
[TD="align: left"]Pus for C/S[/TD]
[TD="align: left"]Escherichia coli[/TD]
[TD="align: left"]Meropenem[/TD]
[TD="align: left"]S[/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: right"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[TD="align: left"][/TD]
[/TR]
</tbody>[/TABLE]
So what I need is that whenever this column's result is different for the same ID number, the output should change the ID number to a new value, say 1304075a and 1304075b instead of 1304075.
[TABLE="width: 884"]
<tbody>[TR]
[TD]13040745a[/TD]
[TD]26:27.4[/TD]
[TD]Hameeda Begum[/TD]
[TD]F[/TD]
[TD]65[/TD]
[TD]Y[/TD]
[TD]Pus for C/S[/TD]
[TD]Escherichia coli[/TD]
[TD]Doxycycline[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD]13040745a[/TD]
[TD]26:27.4[/TD]
[TD]Hameeda Begum[/TD]
[TD]F[/TD]
[TD]65[/TD]
[TD]Y[/TD]
[TD]Pus for C/S[/TD]
[TD]Escherichia coli[/TD]
[TD]Ciprofloxacin[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD]13040745a[/TD]
[TD]26:27.4[/TD]
[TD]Hameeda Begum[/TD]
[TD]F[/TD]
[TD]65[/TD]
[TD]Y[/TD]
[TD]Pus for C/S[/TD]
[TD]Escherichia coli[/TD]
[TD]Gentamicin[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD]13040745a[/TD]
[TD]26:27.4[/TD]
[TD]Hameeda Begum[/TD]
[TD]F[/TD]
[TD]65[/TD]
[TD]Y[/TD]
[TD]Pus for C/S[/TD]
[TD]Escherichia coli[/TD]
[TD]Ampicillin[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD]13040745a[/TD]
[TD]26:27.4[/TD]
[TD]Hameeda Begum[/TD]
[TD]F[/TD]
[TD]65[/TD]
[TD]Y[/TD]
[TD]Pus for C/S[/TD]
[TD]Escherichia coli[/TD]
[TD]Tigecycline[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD]13040745a[/TD]
[TD]26:27.4[/TD]
[TD]Hameeda Begum[/TD]
[TD]F[/TD]
[TD]65[/TD]
[TD]Y[/TD]
[TD]Pus for C/S[/TD]
[TD]Escherichia coli[/TD]
[TD]Sulzone[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD]13040745a[/TD]
[TD]26:27.4[/TD]
[TD]Hameeda Begum[/TD]
[TD]F[/TD]
[TD]65[/TD]
[TD]Y[/TD]
[TD]Pus for C/S[/TD]
[TD]Escherichia coli[/TD]
[TD]Amikacin[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD]13040745a[/TD]
[TD]26:27.4[/TD]
[TD]Hameeda Begum[/TD]
[TD]F[/TD]
[TD]65[/TD]
[TD]Y[/TD]
[TD]Pus for C/S[/TD]
[TD]Escherichia coli[/TD]
[TD]Amoxicillin_Clavulanic acid[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD]13040745a[/TD]
[TD]26:27.4[/TD]
[TD]Hameeda Begum[/TD]
[TD]F[/TD]
[TD]65[/TD]
[TD]Y[/TD]
[TD]Pus for C/S[/TD]
[TD]Escherichia coli[/TD]
[TD]Cotrimoxazole[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD]13040745a[/TD]
[TD]26:27.4[/TD]
[TD]Hameeda Begum[/TD]
[TD]F[/TD]
[TD]65[/TD]
[TD]Y[/TD]
[TD]Pus for C/S[/TD]
[TD]Escherichia coli[/TD]
[TD]Meropenem[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD]13040745a[/TD]
[TD]26:27.4[/TD]
[TD]Hameeda Begum[/TD]
[TD]F[/TD]
[TD]65[/TD]
[TD]Y[/TD]
[TD]Pus for C/S[/TD]
[TD]Escherichia coli[/TD]
[TD]Imipenem[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD]13040745a[/TD]
[TD]26:27.4[/TD]
[TD]Hameeda Begum[/TD]
[TD]F[/TD]
[TD]65[/TD]
[TD]Y[/TD]
[TD]Pus for C/S[/TD]
[TD]Escherichia coli[/TD]
[TD]Ceftriaxone[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD]13040745a[/TD]
[TD]26:27.4[/TD]
[TD]Hameeda Begum[/TD]
[TD]F[/TD]
[TD]65[/TD]
[TD]Y[/TD]
[TD]Pus for C/S[/TD]
[TD]Escherichia coli[/TD]
[TD]Piperacillin_Tazobactam[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD]13040745b[/TD]
[TD]26:27.4[/TD]
[TD]Hameeda Begum[/TD]
[TD]F[/TD]
[TD]65[/TD]
[TD]Y[/TD]
[TD]Pus for C/S[/TD]
[TD]Pseudomonas aeruginosa[/TD]
[TD]Piperacillin_Tazobactam[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD]13040745b[/TD]
[TD]26:27.4[/TD]
[TD]Hameeda Begum[/TD]
[TD]F[/TD]
[TD]65[/TD]
[TD]Y[/TD]
[TD]Pus for C/S[/TD]
[TD]Pseudomonas aeruginosa[/TD]
[TD]Amikacin[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD]13040745b[/TD]
[TD]26:27.4[/TD]
[TD]Hameeda Begum[/TD]
[TD]F[/TD]
[TD]65[/TD]
[TD]Y[/TD]
[TD]Pus for C/S[/TD]
[TD]Pseudomonas aeruginosa[/TD]
[TD]Gentamicin[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD]13040745b[/TD]
[TD]26:27.4[/TD]
[TD]Hameeda Begum[/TD]
[TD]F[/TD]
[TD]65[/TD]
[TD]Y[/TD]
[TD]Pus for C/S[/TD]
[TD]Pseudomonas aeruginosa[/TD]
[TD]Sulzone[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD]13040745b[/TD]
[TD]26:27.4[/TD]
[TD]Hameeda Begum[/TD]
[TD]F[/TD]
[TD]65[/TD]
[TD]Y[/TD]
[TD]Pus for C/S[/TD]
[TD]Pseudomonas aeruginosa[/TD]
[TD]Ceftazidime[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD]13040745b[/TD]
[TD]26:27.4[/TD]
[TD]Hameeda Begum[/TD]
[TD]F[/TD]
[TD]65[/TD]
[TD]Y[/TD]
[TD]Pus for C/S[/TD]
[TD]Pseudomonas aeruginosa[/TD]
[TD]Aztreonam[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD]13040745b[/TD]
[TD]26:27.4[/TD]
[TD]Hameeda Begum[/TD]
[TD]F[/TD]
[TD]65[/TD]
[TD]Y[/TD]
[TD]Pus for C/S[/TD]
[TD]Pseudomonas aeruginosa[/TD]
[TD]Cefepime[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD]13040745b[/TD]
[TD]26:27.4[/TD]
[TD]Hameeda Begum[/TD]
[TD]F[/TD]
[TD]65[/TD]
[TD]Y[/TD]
[TD]Pus for C/S[/TD]
[TD]Pseudomonas aeruginosa[/TD]
[TD]Imipenem[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD]13040745b[/TD]
[TD]26:27.4[/TD]
[TD]Hameeda Begum[/TD]
[TD]F[/TD]
[TD]65[/TD]
[TD]Y[/TD]
[TD]Pus for C/S[/TD]
[TD]Pseudomonas aeruginosa[/TD]
[TD]Meropenem[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD]13040745b[/TD]
[TD]26:27.4[/TD]
[TD]Hameeda Begum[/TD]
[TD]F[/TD]
[TD]65[/TD]
[TD]Y[/TD]
[TD]Pus for C/S[/TD]
[TD]Pseudomonas aeruginosa[/TD]
[TD]Ciprofloxacin[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]S[/TD]
[/TR]
</tbody>[/TABLE]

I would like this code to run on the raw data and give output with only different ID numbers, then I will run the code for extracting drug information later. I know this is an undue favor to ask but I have a project deadline. I tried to do it manually but there are hundreds of duplicates so that is hard.
Thankyou soo much
Regards
Tabi
 
Upvote 0

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Forum statistics

Threads
1,223,911
Messages
6,175,337
Members
452,637
Latest member
Ezio2866

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top