I have an excel spreadsheet (example attached) which is populated by lab equipment. The key field is the specimen number and specimen type. Currently for every antibiotic there is a row with its result. My output is 3 complete worksheets so a lot of data. I need to create a database with one row per specimen number/type to include whether it is S/R/or I for each type of antibiotic. The example probably makes more sense. but I'm assuming that 65000 rows * 3 sheet can then be reduced to around 18,000 rows.
Any help or pointers appreciated. I do this run every week so spend hours reformatting by hand.
thanks
Any help or pointers appreciated. I do this run every week so spend hours reformatting by hand.
thanks