Reorganizing the excel / Normalizing the table

1.Simply I’ll summarize the steps of the script as follows:
Read the XLS file DailyReport_expt.XLS (33 KB)
and extract the data.

2.Build an internal data table for the drug name along with its medication code and either it is a scar medication or a meta medication.

3.organize the XLS file data using the data in the med codes datatable to produce set of data and store it in a final dataTable:

please find the attached .xaml for the solution to this file

medcodesDT (1).xaml (38.4 KB)