not sure if I should be posting excel help here, but it is to do with my GIS work as I am studying GIS at the moment.
I currently have 10 sheets representing 10 years of data.In the sheets I have rows representing objects in images, with an attribute corresponding to the image the object is located in. The image number(Frame) is directly associated with date, and I would like to replace the number with the date. eg 1 -> 01/01/2014
However there are thousands of records and doing this thousands of times over 10 files isn't exactly feasible, as there are multiple objects on each day so the sheet looks something like this.
HEADER1|HEADER2|HEADER3|FRAMENo*
DATA|DATA|DATA|1
DATA|DATA|DATA|1
DATA|DATA|DATA|1
DATA|DATA|DATA|2
DATA|DATA|DATA|2
DATA|DATA|DATA|2
DATA|DATA|DATA|2
DATA|DATA|DATA|3
DATA|DATA|DATA|3
Etc.
I have 2 columns as a key but I do not know how to automatically reassign these values for such a large amount of records.
1|01/01/2004
2|02/01/2004
3|03/01/2004
Etc
Any help would be appreciated. Thanks in advance,
أكثر...
I currently have 10 sheets representing 10 years of data.In the sheets I have rows representing objects in images, with an attribute corresponding to the image the object is located in. The image number(Frame) is directly associated with date, and I would like to replace the number with the date. eg 1 -> 01/01/2014
However there are thousands of records and doing this thousands of times over 10 files isn't exactly feasible, as there are multiple objects on each day so the sheet looks something like this.
HEADER1|HEADER2|HEADER3|FRAMENo*
DATA|DATA|DATA|1
DATA|DATA|DATA|1
DATA|DATA|DATA|1
DATA|DATA|DATA|2
DATA|DATA|DATA|2
DATA|DATA|DATA|2
DATA|DATA|DATA|2
DATA|DATA|DATA|3
DATA|DATA|DATA|3
Etc.
I have 2 columns as a key but I do not know how to automatically reassign these values for such a large amount of records.
1|01/01/2004
2|02/01/2004
3|03/01/2004
Etc
Any help would be appreciated. Thanks in advance,
أكثر...