I have a Freight table which I would like to find the most proficient approach in getting into this normalize state....Below is the sample Freight_Tbl and the second table is my goal for normalization. How can this be accomplish is my question....Thanks in Advance as always...
Freight_Tbl
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Result_Tbl needed....
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Freight_Tbl
City_Dest | State_Dest | Plant | City_Origin | State_Origin | Efffect_Date | Currency | Rate_4 | Rate_6 | Rate_BB | Rate_BG | Rate_AA |
Oxon Hill | Maryland,US | US-MA-Richmond | Kaleen | Texas,US | 5/1/2015 | USD | 55.12 | 23.21 | 45.6 | 0 | 0 |
Oxon Hill | Maryland,US | US-MA-Seattle | Washington | Seattle,US | 5/2/2015 | USD | 48.5 | 26 | 13.55 | 0 | 0 |
Oxon Hill | Maryland,US | US-MA-Petersburg | Petersburg | Virginia,US | 5/3/2015 | USD | 35.15 | 32.58 | 14.5 | 0 | 0 |
Oxon Hill | Maryland,US | US-MA-Ft. Dix | Ft. Dix | New Jersey,US | 5/4/2015 | USD | 45.68 | 21.5 | 32.6 | 0 | 0 |
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Result_Tbl needed....
City_Dest | State_Dest | Plant | City_Origin | State_Origin | Efffect_Date | Currency | Rate_Type | Rate |
Oxon Hill | Maryland,US | US-MA-Richmond | Kaleen | Texas,US | 5/1/2015 | USD | Rate_4 | 55.12 |
Oxon Hill | Maryland,US | US-MA-Seattle | Washington | Seattle,US | 5/2/2015 | USD | Rate_BB | 13.55 |
Oxon Hill | Maryland,US | US-MA-Petersburg | Petersburg | Virginia,US | 5/3/2015 | USD | Rate_6 | 32.58 |
Oxon Hill | Maryland,US | US-MA-Ft. Dix | Ft. Dix | New Jersey,US | 5/4/2015 | USD | Rate_BG | 0 |
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>