Take the chart 1 as input and transform it into the Destination Table... use the tax table to calculate the tax for the region on each record. Capture all of the steps you took to transform the data into the Destination table.

\begin{tabular}{|l|r|l|l|} \hline \multicolumn{1}{|c|}{ A } & \multicolumn{1}{|c}{ B } & C \\ \hline East & 0.06 & \\ \hline Central & 0.07 & \\ \hline West & 0.075 & \\ \hline North & 0.065 & \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline rderDate & Region & Represe & ntative & Item & Units & Unit & ice \\ \hline 17-Nov-14 & Central & Alex & Johnson & Binder & 11 & 4.99 & \\ \hline 9 Feb-15 & Central & Alex & Johnson & Pencil & 36 & 4.99 & \\ \hline 24-Mar-15 & Central & Alex & Johnson & Pen Set & 50 & 4.99 & \\ \hline 5-May-15 & Central & Alex & Johnson & Pencil & 90 & 4.99 & \\ \hline 10-Sep-14 & Central & Bill & wilder & Pencil & 7 & 1.29 & \\ \hline 15 -Jan-15 & Central & Bill & wilder & Binder & 46 & 8.99 & \\ \hline 26 -Feb-15 & Central & Bill & wilder & Pen & 27 & 19.99 & \\ \hline 14-May-15 & Central & Bill & wilder & Pencil & 53 & 1.29 & \\ \hline 31-May-15 & Central & Bill & wilder & Binder & 80 & 8.99 & \\ \hline 24-Aug-14 & West & James & Tramell & Desk & 3 & 275 & \\ \hline 27 -Sep-14 & West & James & Tramell & Pen & 76 & 1.99 & \\ \hline 7-Mar-15 & West & James & Tramell & Binder & 7 & 19.99 & \\ \hline 15-Mar-15 & West & James & Tramell & Pencil & 56 & 2.99 & \\ \hline 7-Aug-14 & Central & Matthew & Bruno & Pen set & 42 & 23.95 & \\ \hline 25 -Nov-14 & Central & Matthew & Bruno & Pen Set & 96 & 4.99 & \\ \hline 23 -Jan-15 & Central & Matthew & Bruno & Binder & 50 & 19.99 & \\ \hline 17-Jun-15 & Central & Matthew & Bruno & Desk & 5 & 125 & \\ \hline 12-Jul-14 & East & Nick & Smith & Binder & 29 & 1.99 & \\ \hline 27-Apr-15 & East & Nick & Smith & Pen & 96 & 4.99 & \\ \hline 31-Oct-14 & Central & Rachel & \multicolumn{2}{|c|}{ Von Handorf } & Pencil & 14 & 1.29 \\ \hline 18-Apr-15 & Central & Rachel & \multicolumn{2}{|c|}{ Von Handorf } & Pencil & 75 & 1.99 \\ \hline 4-Jul-14 & East & Richard & \multicolumn{2}{|c|}{ Von Handorf } & Pen Set & 62 & 4.99 \\ \hline 15-Aug-14 & East & Richard & \multicolumn{2}{|c|}{ Von Handorf } & Pencil & 35 & 4.99 \\ \hline 18-Sep-14 & East & Richard & \multicolumn{2}{|c|}{ Von Handorf } & Pen Set & 16 & 15.99 \\ \hline 1Apr15 & East & Richard & \multicolumn{2}{|c|}{ Von Handorf } & Binder & 60 & 4.99 \\ \hline 8-Jun-15 & East & Richard & \multicolumn{2}{|c|}{ Von Handorf } & Binder & 60 & 8.99 \\ \hline 1-Sep-14 & Central & Smith & \multicolumn{2}{|l|}{ Peterson } & Desk & 2 & 125 \\ \hline 12-Dec-14 & Central & Smith & \multicolumn{2}{|l|}{ Peterson } & Pencil & 67 & 1.29 \\ \hline 1 -Feb-15 & Central & Smith & \multicolumn{2}{|l|}{ Peterson } & Binder & 87 & 15 \\ \hline 29Jul14 & East & Susan & Wilson & Binder & 81 & 19.99 & \\ \hline 8 -Nov-14 & East & Susan & Wilson & Pen & 15 & 19.99 & \\ \hline 29-Dec-14 & East & Susan & Wilson & Pen set & 74 & 15.99 & \\ \hline 14-Oct-14 & West & Thomas & Benoit & Binder & 57 & 19.99 & \\ \hline & & & & & 32 & 2000 & \\ \hline \end{tabular} \begin{tabular}{|l|r|l|l|} \hline \multicolumn{1}{|c|}{ A } & \multicolumn{1}{|c}{ B } & C \\ \hline East & 0.06 & \\ \hline Central & 0.07 & \\ \hline West & 0.075 & \\ \hline North & 0.065 & \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline rderDate & Region & Represe & ntative & Item & Units & Unit & ice \\ \hline 17-Nov-14 & Central & Alex & Johnson & Binder & 11 & 4.99 & \\ \hline 9 Feb-15 & Central & Alex & Johnson & Pencil & 36 & 4.99 & \\ \hline 24-Mar-15 & Central & Alex & Johnson & Pen Set & 50 & 4.99 & \\ \hline 5-May-15 & Central & Alex & Johnson & Pencil & 90 & 4.99 & \\ \hline 10-Sep-14 & Central & Bill & wilder & Pencil & 7 & 1.29 & \\ \hline 15 -Jan-15 & Central & Bill & wilder & Binder & 46 & 8.99 & \\ \hline 26 -Feb-15 & Central & Bill & wilder & Pen & 27 & 19.99 & \\ \hline 14-May-15 & Central & Bill & wilder & Pencil & 53 & 1.29 & \\ \hline 31-May-15 & Central & Bill & wilder & Binder & 80 & 8.99 & \\ \hline 24-Aug-14 & West & James & Tramell & Desk & 3 & 275 & \\ \hline 27 -Sep-14 & West & James & Tramell & Pen & 76 & 1.99 & \\ \hline 7-Mar-15 & West & James & Tramell & Binder & 7 & 19.99 & \\ \hline 15-Mar-15 & West & James & Tramell & Pencil & 56 & 2.99 & \\ \hline 7-Aug-14 & Central & Matthew & Bruno & Pen set & 42 & 23.95 & \\ \hline 25 -Nov-14 & Central & Matthew & Bruno & Pen Set & 96 & 4.99 & \\ \hline 23 -Jan-15 & Central & Matthew & Bruno & Binder & 50 & 19.99 & \\ \hline 17-Jun-15 & Central & Matthew & Bruno & Desk & 5 & 125 & \\ \hline 12-Jul-14 & East & Nick & Smith & Binder & 29 & 1.99 & \\ \hline 27-Apr-15 & East & Nick & Smith & Pen & 96 & 4.99 & \\ \hline 31-Oct-14 & Central & Rachel & \multicolumn{2}{|c|}{ Von Handorf } & Pencil & 14 & 1.29 \\ \hline 18-Apr-15 & Central & Rachel & \multicolumn{2}{|c|}{ Von Handorf } & Pencil & 75 & 1.99 \\ \hline 4-Jul-14 & East & Richard & \multicolumn{2}{|c|}{ Von Handorf } & Pen Set & 62 & 4.99 \\ \hline 15-Aug-14 & East & Richard & \multicolumn{2}{|c|}{ Von Handorf } & Pencil & 35 & 4.99 \\ \hline 18-Sep-14 & East & Richard & \multicolumn{2}{|c|}{ Von Handorf } & Pen Set & 16 & 15.99 \\ \hline 1Apr15 & East & Richard & \multicolumn{2}{|c|}{ Von Handorf } & Binder & 60 & 4.99 \\ \hline 8-Jun-15 & East & Richard & \multicolumn{2}{|c|}{ Von Handorf } & Binder & 60 & 8.99 \\ \hline 1-Sep-14 & Central & Smith & \multicolumn{2}{|l|}{ Peterson } & Desk & 2 & 125 \\ \hline 12-Dec-14 & Central & Smith & \multicolumn{2}{|l|}{ Peterson } & Pencil & 67 & 1.29 \\ \hline 1 -Feb-15 & Central & Smith & \multicolumn{2}{|l|}{ Peterson } & Binder & 87 & 15 \\ \hline 29Jul14 & East & Susan & Wilson & Binder & 81 & 19.99 & \\ \hline 8 -Nov-14 & East & Susan & Wilson & Pen & 15 & 19.99 & \\ \hline 29-Dec-14 & East & Susan & Wilson & Pen set & 74 & 15.99 & \\ \hline 14-Oct-14 & West & Thomas & Benoit & Binder & 57 & 19.99 & \\ \hline & & & & & 32 & 2000 & \\ \hline \end{tabular}