Update Transformations

please make the following changes to transformation cell 10: producer_location will be state, city (not address) Need Macro Ship To location as well - City, State In the final view I do not need Material_code and Material_name, Add a column named Producer and have all values Hexion underneath... (Budget: ₹3000 - ₹3500 INR, Jobs: Data Analysis, Data Entry, Data Integration, Data Management, Data Processing, Data Visualization, Excel, Visual Basic)