Hi guys,
I am trying to write a script which populates a bigger data set from the original sheet to created template ("proforma").
I am okay with most of it, however, there is a part that I struggle with - the location split.
While in the original sheet the location is placed in one column ( yet includes two types of 3 string address, which slightly differ in terms of deliminator as one type contains a street and one type classic - city, region, country format) the proforma sheet needs to accommodate the split of both types of addresses.
Attached is the sample of data - Please note the split in the street address instances (where street address is given) as the zip code field and the street input have to be populated in separate columns. The second type of input i.e. city,region,country entry also requires split and subsequent input in different cells.
Please note that all string inputs (placed in distinct cells) have to be on a separate line.
Thank you very much for looking into this.
Kind regards,
Velehrad
Bookmarks