I need to show the data on the MIC and Interpret fields on the report by creating 3 columns, depending on Specimen Type field.
If the Organism field is negative, the MIC and Interpret fields are blank.
Is it possible?
Thank you in advance for any help you can provide!
Report
Sample ID GC12
Sputum Urine Wound Antimicrobials MIC Interpret MIC Interpret MIC Interpret Azithromycin 0.047 S 0.094 S Cefixime <=0.016 S <=0.016 S Ceftriaxone 0.25 S 0.25 S Ciprofloxacin 0.5 I 1 R Gentamicin 2 S >=32 R Penicillin 8 R 8 R Tetracycline 6 R 12 R
Form
Sample ID Specimen Type Organism Antimicrobial MIC Interpret GC12 Sputum Positive Azithromycin 0.047 S GC12 Sputum Positive Cefixime <=0.016 S GC12 Sputum Positive Ceftriaxone 0.25 S GC12 Sputum Positive Ciprofloxacin 0.5 I GC12 Sputum Positive Gentamicin 2 S GC12 Sputum Positive Penicillin 8 R GC12 Sputum Positive Tetracycline 6 R GC12 Urine Positive Azithromycin 0.094 S GC12 Urine Positive Cefixime <=0.016 S GC12 Urine Positive Ceftriaxone 0.25 S GC12 Urine Positive Ciprofloxacin 1 R GC12 Urine Positive Gentamicin >=32 R GC12 Urine Positive Penicillin 8 R GC12 Urine Positive Tetracycline 12 R GC12 Wound Negative