I have a series of features, split by complex, group and site. Each feature has various attributes at the site level such as PERIOD and TYPE. I need to be able to group all the features at the Group level, giving all the attributes from a group to each group; e.g. if I have 3 sites in group TV1.3 with different attributes (TV1.3.1 PERIOD = BRONZE AGE and TYPE = ROUND BARROW; TV1.3.2 PERIOD = BRONZE AGE and TYPE = POND BARROW; TV1.3.3 PERIOD = BRONZE AGE and TYPE = SAUCER BARROW) I want to create a table where TV1.3 PERIOD = BRONZE AGE and TYPE = ROUND BARROW\POND BARROW\SAUCER BARROW.
Is this possible, and if so how might I do it?
I attach a small sample of data.