Customer Data Cleanse

To be updated and cleansed as follows:

Column A & B: Do not amend
Column C: Add missing postcodes (Minimum 3 & Maximum 15 characters, these postcodes will also be used in column “S”)
Column E,G,I,K & M: Do Not Amend
Column O: Add missing City (Maximum 35 characters)
Column Q: Add missing county (Maximum 35 characters)
Column S: Add missing postcodes (Minimum 3 & Maximum 15 characters, these postcodes will also be used in column “C”)
Columns: U & W: Do not amend
Column Y: Add missing telephone number
Column AA: Do not amend

Data to be entered in the same format as existing information