please help

For each example select the appropriate Data Standardization process or issue. An address field includes street address, city, state, and zip code in one cell. The components should be A. Cryptic Data Values separated into individual cells for each component to allow data analysis by zip code for example. B. Data Concatenation Create a unique identifier for a product code by combining the item code and the department code. C. Data Parsing Add new columns to identify the meanings behind the item code and the department code. D. Data Consistency The City field contains the data value "Germany." E. Misfielded Data Values Some phone numbers are formatted as (330) 123-4567 and others are formatted as 330-123-4567