Spreadsheet: 75342d1275928047-converting-rows-to-columns-meds
Sheet: Sheet1

ID | RID | VISCODE | EXAMDATE | CMMED | CMHFS | CMDOSE | CMFREQNC | CMROUTE | CMREASON | CMBGN | CMCONT | CMEND
18 | 2 | sc | 2005-08-17 00:00:00 | Aspirin | -4 | 81 | QD | P.O | stroke prophylaxis | --/--/2000 | 0 | 2006-01-07 00:00:00
108 | 2 | bl | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4
3514 | 2 | m06 | 2006-03-06 00:00:00 | meclizine | -4 | 12.5 mg | prn | po | dizziness | 2006-01-12 00:00:00 | 0 | 06/--/2006
3516 | 2 | m06 | 2006-03-06 00:00:00 | [NAME] | -4 | 500 mg | qd | po | pneumonia | 2006-01-11 00:00:00 | 0 | 2006-01-17 00:00:00
28266 | 2 | m36 | 2008-08-27 00:00:00 | ASPIRIN | -4 | 81MG | QDAY | PO | STROKE PROPHYLAXIS | 2007-07-10 00:00:00 | 1 | -4
20 | 3 | sc | 2005-08-18 00:00:00 | razadyne | -4 | 12mg | BID | PO | alzheimers | 12/--/2003 | 0 | 11/--/2006
22 | 3 | sc | 2005-08-18 00:00:00 | lipitor | -4 | 10 mg | [NAME] | PO | hyperlipidemia | --/--/1995 | 1 | -4
24 | 3 | sc | 2005-08-18 00:00:00 | cardura | -4 | 2 mg | [NAME] | PO | hypertension | --/--/1995 | 0 | 11/--/2006
26 | 3 | sc | 2005-08-18 00:00:00 | tapazole | -4 | 10 mg | [NAME] | PO | hyperthyroid | --/--/1985 | 0 | 2006-11-20 00:00:00
28 | 3 | sc | 2005-08-18 00:00:00 | multivitamin | -4 | .T | QD | PO | health supplement | --/--/2001 | 1 | -4
30 | 3 | sc | 2005-08-18 00:00:00 | vitamin c | -4 | 500 mg | QD | PO | health supplement | --/--/2001 | 1 | -4
32 | 3 | sc | 2005-08-18 00:00:00 | aspirin | -4 | 81 mg | QD | PO | stroke prophylaxis | --/--/2003 | 1 | -4
34 | 3 | sc | 2005-08-18 00:00:00 | ibuprofen | -4 | 200 mg | BID | PO | osteoarthritis | 05/--/2005 | 1 | -4
114 | 3 | bl | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4
3756 | 3 | m06 | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4
11816 | 3 | m12 | 2006-09-12 00:00:00 | namenda | -4 | 10 mg | bid | po | alzheimer's | 2006-08-28 00:00:00 | 1 | -4
11818 | 3 | m12 | 2006-09-12 00:00:00 | namenda | -4 | 5mg | 1 tab in the AM | po | alzheimer's | 2006-08-21 00:00:00 | 0 | 2006-08-28 00:00:00
11820 | 3 | m12 | 2006-09-12 00:00:00 | namenda | -4 | 5 mg | bid | po | alzheimer's | 2006-08-14 00:00:00 | 0 | 2006-08-21 00:00:00
11822 | 3 | m12 | 2006-09-12 00:00:00 | namenda | -4 | 5 mg | qd | po | alzheimer's | 2006-08-07 00:00:00 | 0 | 2006-08-14 00:00:00
11824 | 3 | m12 | 2006-09-12 00:00:00 | namenda | -4 | 10 mg | qhs | po | alzheimer's | 2006-08-21 00:00:00 | 0 | 2006-08-28 00:00:00
19894 | 3 | m18 | 2007-03-12 00:00:00 | TAPAZOLE | -4 | 5MG | QD | PO | HYPERTHYROID | 11/--/2006 | 1 | -4
19896 | 3 | m18 | 2007-03-12 00:00:00 | CARDURA | -4 | 4MG | QHS | PO | HYPERTENSION | 11/--/2006 | 1 | -4
23018 | 3 | m24 | 2007-09-12 00:00:00 | RAZADYNE | -4 | 16MG | QD | PO | ALZHEIMERS | 11/--/2006 | 1 | -4
36 | 4 | sc | 2005-08-18 00:00:00 | Atorvastatin | -4 | 20mg | QD | PO | Hypercholesterolemia | 2003-11-01 00:00:00 | 0 | 2006-09-21 00:00:00
38 | 4 | sc | 2005-08-18 00:00:00 | Doxazosin | -4 | 2mg | QD | PO | Benign Prostatic Hyperplasia | 2005-06-08 00:00:00 | 0 | 2005-11-03 00:00:00
40 | 4 | sc | 2005-08-18 00:00:00 | [NAME] | -4 | 10mg | QD | PO | Hypertension | 2005-06-08 00:00:00 | 0 | 02/--/2006
42 | 4 | sc | 2005-08-18 00:00:00 | Piroxicam | -4 | 20mg | PRN/QD | PO | Osteoarthritis | 2005-01-13 00:00:00 | 0 | 2005-10-01 00:00:00
44 | 4 | sc | 2005-08-18 00:00:00 | Fish Oil | -4 | One Tablet | QD | PO | Nutrition Supplement | 2004-10-01 00:00:00 | 1 | -4
46 | 4 | sc | 2005-08-18 00:00:00 | Vitamin C | -4 | 500mg | QD | PO | nutrition supplement | 2004-10-01 00:00:00 | 1 | -4
48 | 4 | sc | 2005-08-18 00:00:00 | Aricept | -4 | 5mg | QD | PO | Memory Problems | 2005-07-10 00:00:00 | 1 | -4
794 | 4 | bl | 2005-11-08 00:00:00 | Acetaminophen | -4 | two 500mg tablets | qid | PO | Osteoarthritis | 2005-10-02 00:00:00 | 1 | -4
796 | 4 | bl | 2005-11-08 00:00:00 | Doxazosin | -4 | 4 mg | qd | PO | Benign Prostatic Hyperplasia | 2005-11-04 00:00:00 | 1 | -4
6154 | 4 | m06 | 2006-05-02 00:00:00 | Vitamin E | -4 | 400 IU | qd | po | nutrition supplement | 11/--/2005 | 0 | 2006-11-14 00:00:00
6156 | 4 | m06 | 2006-05-02 00:00:00 | Calcuim plus Vitamin D | -4 | 600mg | qd | po | nutrition supplement | 11/--/2005 | 0 | 02/--/2007
6158 | 4 | m06 | 2006-05-02 00:00:00 | Glucosamine | -4 | 100mg | qd | po | nutrition supplement | 04/--/2006 | 0 | 2006-11-14 00:00:00
6160 | 4 | m06 | 2006-05-02 00:00:00 | Proscar | -4 | 5mg | qd | po | prostate | 02/--/2006 | 0 | 02/--/2007
6162 | 4 | m06 | 2006-05-02 00:00:00 | Norvasc | -4 | 10mg | qd | po | HTN | 04/--/2006 | 1 | -4
6164 | 4 | m06 | 2006-05-02 00:00:00 | Enapril | -4 | 10mg | bid | po | HTN | 02/--/2006 | 0 | 02/--/2007
15018 | 4 | m12 | 2006-11-14 00:00:00 | Atrovastatin | -4 | 40mg | qd | po | High Cholesterol | 2006-09-22 00:00:00 | 0 | 02/--/2007
21636 | 4 | m18 | 2007-05-14 00:00:00 | Prosar | -4 | 10mg | daily | po | Prostate | 02/--/2007 | 1 | -4
21638 | 4 | m18 | 2007-05-14 00:00:00 | [NAME] | -4 | 20mg | bid | po | HTN | 02/--/2007 | 1 | -4
21640 | 4 | m18 | 2007-05-14 00:00:00 | Lipitor | -4 | 80mg | daily | po | High Cholesterol | 02/--/2007 | 1 | -4
21642 | 4 | m18 | 2007-05-14 00:00:00 | Vitamin A | -4 | 800 IU | daily | po | Nutrition Supplement | 02/--/2007 | 0 | 11/--/2008
28032 | 4 | m30 | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4
29334 | 4 | m36 | 2008-11-18 00:00:00 | Vitamin E | -4 | 1000 IU | daily | PO | Nutrition Supplement | 11/--/2008 | 1 | -4
29484 | 4 | m36 | 2008-11-18 00:00:00 | Omeprazol | -4 | 20 mg | daily | PO | GERD | 2007-08-30 00:00:00 | 0 | 2008-11-17 00:00:00
50 | 5 | sc | 2005-08-23 00:00:00 | betoptics | -4 | 1 gtt | BID | OU | glaucoma | --/--/2000 | 0 | 2005-09-21 00:00:00
52 | 5 | sc | 2005-08-23 00:00:00 | xalatan | -4 | 1 gtt | QD | OU | glaucoma | --/--/2004 | 1 | -4
54 | 5 | sc | 2005-08-23 00:00:00 | mvi | -4 | one | QD | PO | health supplement | --/--/1995 | 0 | 2008-04-15 00:00:00
56 | 5 | sc | 2005-08-23 00:00:00 | vit c | -4 | 500 mg | QD | PO | health supplement | --/--/1995 | 0 | 2008-03-03 00:00:00
58 | 5 | sc | 2005-08-23 00:00:00 | vit e | -4 | 200 iu | QD | PO | health supplement | --/--/1995 | 0 | 2008-03-03 00:00:00
60 | 5 | sc | 2005-08-23 00:00:00 | zinc | -4 | 50 mg | QD | PO | health supplement | --/--/1995 | 1 | -4
62 | 5 | sc | 2005-08-23 00:00:00 | ASA | -4 | 81 mg | QD | PO | stroke prophylaxis | --/--/2000 | 0 | 07/--/2006
64 | 5 | sc | 2005-08-23 00:00:00 | calcium plus | -4 | 800 mg | QD | PO | health supplement | --/--/1995 | 1 | -4
66 | 5 | sc | 2005-08-23 00:00:00 | glucosamine chondrotin | -4 | 1000 mg | QD | PO | glaucoma | --/--/2000 | 1 | -4
110 | 5 | bl | 2005-09-07 00:00:00 | cosopt | -4 | one drop | BID | OU | glaucoma | 07/--/2005 | 1 | -4
3622 | 5 | m06 | 2006-03-09 00:00:00 | lipitor | -4 | 10 mg | qhs | po | CAD | 2005-10-13 00:00:00 | 0 | 07/--/2006
3628 | 5 | m06 | 2006-03-09 00:00:00 | erythromycin | -4 | -1 | x 1 | po | infection/fever | 2006-03-08 00:00:00 | 0 | 2006-03-08 00:00:00
3630 | 5 | m06 | 2006-03-09 00:00:00 | plavix | -4 | 75 mg | qd | po | CAD | 2005-10-13 00:00:00 | 0 | 07/--/2006
3634 | 5 | m06 | 2006-03-09 00:00:00 | tylenol | -4 | 650 mg | prn | po | headaches | 2006-03-05 00:00:00 | 1 | -4
11562 | 5 | m12 | 2006-09-05 00:00:00 | simvastatin | -4 | 40 mg | qd | po | CAD | 07/--/2006 | 1 | -4
11566 | 5 | m12 | 2006-09-05 00:00:00 | ASA | -4 | 325 mg | qd | po | stroke prophylaxis | 07/--/2006 | 1 | -4
11568 | 5 | m12 | 2006-09-05 00:00:00 | metrocream | -4 | 0.75 mg | bid | topical | rosecea | --/--/2004 | 1 | -4
19886 | 5 | m18 | 2007-03-09 00:00:00 | MILL FLAX SEED OIL | -4 | 1 TABLET | QD | P.O | HEALTH SUPPLEMENT | 01/--/2007 | 1 | -4
22974 | 5 | m24 | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4
26630 | 5 | m30 | 2008-05-02 00:00:00 | omega 3 | -4 | 1 tab | q day | po | health supplement | 2008-03-03 00:00:00 | 1 | -4
28380 | 5 | m36 | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4
772 | 6 | sc | 2005-11-07 00:00:00 | atenolol/chlorthal 50/25 | -4 | .5 [NAME] | once daily | po | high blood pressure | --/--/2004 | 1 | -4
774 | 6 | sc | 2005-11-07 00:00:00 | Fosamax | -4 | 70mg | once weekly | po | osteoporosis prevention | --/--/2001 | 1 | -4
776 | 6 | sc | 2005-11-07 00:00:00 | Lipitor | -4 | 40mg | once daily | po | high cholesterol | --/--/2000 | 1 | -4
778 | 6 | sc | 2005-11-07 00:00:00 | Mirtazapine | -4 | 7.5mg | once daily | po | decreased appetite | 04/--/2005 | 0 | 09/--/2007
780 | 6 | sc | 2005-11-07 00:00:00 | [NAME] | -4 | 7.5mg | twice daily | po | [NAME] | --/--/2000 | 0 | 08/--/2006
782 | 6 | sc | 2005-11-07 00:00:00 | synthroid | -4 | 112mcg | once daily | po | s/p thyroidectomy | --/--/1958 | 1 | -4
784 | 6 | sc | 2005-11-07 00:00:00 | ASA | -4 | 81mg | once daily | po | heart prevention | --/--/2000 | 1 | -4
786 | 6 | sc | 2005-11-07 00:00:00 | Caltrate 600 plus | -4 | 1 tablet | twice daily | po | general health | --/--/2002 | 1 | -4
788 | 6 | sc | 2005-11-07 00:00:00 | [NAME] | -4 | 1 tablet | once daily | po | general health | --/--/1995 | 1 | -4
790 | 6 | sc | 2005-11-07 00:00:00 | [NAME] | -4 | 1250mg | twice daily | po | general health | --/--/2000 | 1 | -4
792 | 6 | sc | 2005-11-07 00:00:00 | Zantac | -4 | 75mg | once daily | po | GERD | --/--/2000 | 1 | -4
960 | 6 | bl | 2005-11-29 00:00:00 | Ocuvite Preservision | -4 | one tablet | twice daily | po | macular degeneration | 2005-11-22 00:00:00 | 1 | -4
15266 | 6 | m12 | 2006-11-20 00:00:00 | meloxicam | -4 | 7.5mg | bid | po | joint pain | 08/--/2006 | 1 | -4
17820 | 6 | m06 | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4
21144 | 6 | m18 | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4
23988 | 6 | m24 | 2007-11-08 00:00:00 | curcumin | -4 | 665mg | bid | po | joint pain | 08/--/2007 | 1 | -4
23990 | 6 | m24 | 2007-11-08 00:00:00 | iron | -4 | 325mg | bid | po | anemia | 08/--/2007 | 0 | 12/--/2007
27292 | 6 | m30 | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4
29496 | 6 | m36 | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4
74 | 7 | sc | 2005-08-25 00:00:00 | Namenda | -4 | 10 mg | QD | PO | Memory Loss | 2003-08-01 00:00:00 | 1 | -4
76 | 7 | sc | 2005-08-25 00:00:00 | [NAME] | -4 | 80 mg | QD | PO | Hypercholesterlemia | 2004-01-01 00:00:00 | 1 | -4
78 | 7 | sc | 2005-08-25 00:00:00 | Paroxetine | -4 | 20 mg | QD | PO | Anxiety | 2005-01-01 00:00:00 | 0 | 10/--/2005
80 | 7 | sc | 2005-08-25 00:00:00 | Amaryl | -4 | 1 mg | QD | PO | Diabetes | 2003-08-01 00:00:00 | 1 | -4
82 | 7 | sc | 2005-08-25 00:00:00 | [NAME] | -4 | 12 mg | QD | PO | Hypertension | 2002-08-01 00:00:00 | 0 | 2007-05-31 00:00:00
414 | 7 | bl | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4 | -4
582 | 7 | sc | 2005-09-25 00:00:00 | Aricept | -4 | 10 mg | QD | PO | Memory loss | 2003-08-01 00:00:00 | 0 | 2006-08-03 00:00:00
584 | 7 | sc | 2005-08-25 00:00:00 | Vitamin E | -4 | 400 IU | QD | PO | Nutrition Supplement | 2005-01-01 00:00:00 | 1 | -4
5344 | 7 | m06 | 2006-04-13 00:00:00 | Celebrex | -4 | 200mg | bid | PO | Arthritis | 03/--/2006 | 0 | 04/--/2006
5346 | 7 | m06 | 2006-04-13 00:00:00 | Desoximetasone ointment | -4 | 0.0025 | bid | topical | skin inflammation | 02/--/2006 | 0 | 08/--/2006
13268 | 7 | m12 | 2006-10-10 00:00:00 | Vitamin C | -4 | 500 mg | qd | PO | Nutrition Supplement | 2006-08-03 00:00:00 | 0 | 03/--/2007
20534 | 7 | m18 | 2007-04-12 00:00:00 | Naproxen | -4 | 375mg | daily | PO | Arthritis | 02/--/2007 | 1 | -4
23586 | 7 | m24 | 2007-10-09 00:00:00 | Paroxetine | -4 | 20mg | daily | PO | Anxiety | 2007-10-09 00:00:00 | 1 | -4
23588 | 7 | m24 | 2007-10-09 00:00:00 | Dicyclomine | -4 | 10mg | tid | PO | Abdominal Pain | 2007-10-01 00:00:00 | 0 | 2007-10-05 00:00:00
23590 | 7 | m24 | 2007-10-09 00:00:00 | Citrucel | -4 | one envelope | qd | PO | Gastric Discomfort/ Fiber Supplement | 2007-10-01 00:00:00 | 0 | 2007-10-05 00:00:00
23652 | 7 | m24 | 2007-10-09 00:00:00 | ASA | -4 | 81mg | daily | PO | Circulation | 2007-05-31 00:00:00 | 1 | -4
23654 | 7 | m24 | 2007-10-09 00:00:00 | [NAME] | -4 | 160mg | daily | PO | Hypertension | 2007-05-31 00:00:00 | 1 | -4