You can create a new spreadsheet and copy the address cell but add the client name referencing the client name cell, then remap that new cell as address field.