I have a raw Excel file filled with location records that needs tidying up. Your first step will be to scrub the sheet so every duplicate location disappears. Once the data is unique, I’d like you to lay it out in a clear, consistent structure. Rather than following a canned template, you'll follow a custom format to make the data integrate to an online platform location finder; I’ll sign off on that layout before you begin the bulk of the work. The final worksheet must contain exactly these columns:see files first